What are the advantages of stored procedures, triggers,
indexes?
Answer Posted / riyas_isno
Triggers are used to identify changes (like insert,update
or delete) in database tables and captured in temp tables
seperately....it helps in business level logics...
procedures contains group of sql statements which are
precompiled ones.....
indexes helps in speedup our execution...
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How can you change the name of any existing table by using the sql statement?
How do I start and stop mysql on windows?
How many columns can be used for creating Index?
Can you tell the difference between $message and $$message?
What is full text indexing in mysql?
How can you validate emails using a single query?
can you tell how can you display the maximum salary in sql? : Mysql dba
What is delimiter in mysql trigger?
Can I install mysql on mac?
What is 'mysqlshow'?
What is auto increment in mysql?
Can you tell what are various ways to create an index?
How do I start mysql client?
What are the differences between char and varchar?
How can you handle the –secure-file-priv in mysql?