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
How internally data stores in MyISAM and INNODB table types?
What is view? How can you create and drop view in mysql?
How many rows can be inserted in mysql at a time?
How do I create a mysql username and password?
How do I insert multiple rows in a table?
How do I create a new database in mysql?
What is offset limit?
What do you mean by % and _ in the LIKE statement?
Is mysql better than oracle?
How do I use mysql?
How can I compare two mysql databases?
What are the non-standard sql commands supported by 'mysql'?
How do I quit mysql?
What is the purpose of mysql database?
Why is the basic difference between left join, right join and inner join?