Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the advantages of stored procedures, triggers,
indexes?

Answer Posted / riyas_isno

Triggers are used to identify changes (like insert,update
or delete) in database tables and captured in temp tables
seperately....it helps in business level logics...

procedures contains group of sql statements which are
precompiled ones.....

indexes helps in speedup our execution...

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you change the name of any existing table by using the sql statement?

940


How do I start and stop mysql on windows?

937


How many columns can be used for creating Index?

984


Can you tell the difference between $message and $$message?

909


What is full text indexing in mysql?

900


How can you validate emails using a single query?

837


can you tell how can you display the maximum salary in sql? : Mysql dba

810


What is delimiter in mysql trigger?

897


Can I install mysql on mac?

931


What is 'mysqlshow'?

987


What is auto increment in mysql?

912


Can you tell what are various ways to create an index?

818


How do I start mysql client?

897


What are the differences between char and varchar?

1040


How can you handle the –secure-file-priv in mysql?

884