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 to convert character strings to numeric values?
How do I install mysql on windows 10 64 bit?
How do I start mysql database?
What is the use of mysqli_connect in php?
What are the column comparisons operators?
Can you tell the difference between $message and $$message?
Can you tell how to find the number of rows in a resultset using php?
What does schema mean?
What is mysql in linux?
Can you tell how many values can set the function of mysql to consider?
How to get the current date in mysql?
How is myisam table stored?
What is table level locking in mysql?
what is constraints? Also explain the different types of constraints?
How do I start mysql?