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

How internally data stores in MyISAM and INNODB table types?

2081


What is view? How can you create and drop view in mysql?

477


How many rows can be inserted in mysql at a time?

489


How do I create a mysql username and password?

494


How do I insert multiple rows in a table?

453






How do I create a new database in mysql?

473


What is offset limit?

482


What do you mean by % and _ in the LIKE statement?

532


Is mysql better than oracle?

466


How do I use mysql?

480


How can I compare two mysql databases?

484


What are the non-standard sql commands supported by 'mysql'?

505


How do I quit mysql?

481


What is the purpose of mysql database?

473


Why is the basic difference between left join, right join and inner join?

546