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

What is the difference between char and varchar?

540


Is mysql same as sql?

476


What language is mysql written in?

493


What is pdo mysql?

498


What is the return type of mysqli_query?

458






What is the phantom problem?

494


Explain % and _ inside like statement?

579


Can foreign key have duplicate values?

502


How many ways to get the current time?

505


What is unique key in mysql?

507


How do I start mysql database?

470


What is the maximum no of columns a table can have?

461


How do I delete a mysql user?

456


How do I select a database in mysql workbench?

490


What is data type for image in mysql?

449