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 to convert character strings to numeric values?

1101


How do I install mysql on windows 10 64 bit?

904


How do I start mysql database?

958


What is the use of mysqli_connect in php?

891


What are the column comparisons operators?

1218


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

946


Can you tell how to find the number of rows in a resultset using php?

889


What does schema mean?

925


What is mysql in linux?

1008


Can you tell how many values can set the function of mysql to consider?

961


How to get the current date in mysql?

1037


How is myisam table stored?

950


What is table level locking in mysql?

892


what is constraints? Also explain the different types of constraints?

942


How do I start mysql?

878