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 to enter boolean values in sql statements?
Can you tell what are various ways to create an index?
Which is faster innodb or myisam?
Which datatype is used for email in mysql?
What do you understand by mysql terminal?
What is the default port for mysql and how it can change?
What is not null in mysql?
What are the purposes of using enum and set data types?
How to find the unique values if the value in the column is repeated?
What is bigint in mysql?
What is acid in mysql?
If you wish to encrypt the username and password using php, how will you do that?
How to create trigger in mysql phpmyadmin?
Where is mysql data stored?
How do I start and stop mysql server?