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
Why mysql is open source?
How do I switch users in mysql?
What is the maximum size of table in mysql?
What is the use of i-am-a-dummy flag in mysql?
What is pdo connection?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What is the datatype for password in mysql?
When to use order by in delete statement?
can you tell how can you display the maximum salary in sql? : Mysql dba
How do I stop a mysql command?
What is the difference between heap table and temporary table?
How to dump one database for backup.
What are all the Common SQL Function?
What is the difference between database and table?
How to change a password for an existing user via mysqladmin?