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 is the advantage of stored procedures, triggers and
indexing in mysql

Answer Posted / lijo

SP's Stored procedures in simple words is a complied SQL
stt. where there is no need for compiling it again on
successive calls.

Trigger is mechanism to handle insert/update.., like
operation happening in database.

Index are used for searching where searching a indexed data
takes less time while comparing with un-indexed.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I start mysql manually?

860


Is null in mysql?

813


How can you export the table as an xml file in mysql?

839


What are the indexes in mysql?

940


How do you connect MySQL database with PHP?

924


What is the difference between unix timestamps and mysql timestamps?

950


How do I install mysql?

835


What is MySQL?

933


What causes mysql too many connections?

873


Who owns mysql database?

986


What are the differences between a primary key and foreign key?

1031


What is RMS Migrations

2346


What are the limitations of mysql?

974


How do I connect to a database in mysql workbench?

967


How show all tables in mysql query?

862