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

Answer Posted / manish jha

Triggers are automatic executable statement.

A stored procedure is a set of SQL commands that has been
compiled & stored on the database server.

Indexs hepls to execute queries fast.

Is This Answer Correct ?    20 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are date and time functions in mysql?

573


Can you rename a database in mysql?

534


Does insert statement lock the table?

510


How to use like conditions?

548


What is action query?

506






Is there a free version of mysql?

481


How to update info already in a table and delete a row(s) from a table.

457


What is mysql_query?

465


How can you move the master database

1523


How to use triggers to track changes in mysql?

487


What is the use of innodb in mysql?

483


What is schema in mysql?

500


What is datatype in mysql?

479


How would you get the current date in mysql?

652


Explain the different types of constraints?

522