What are the advantages of stored procedures, triggers,
indexes?
Answer Posted / jeyakumar
stored procedure:
Stored procedure is a collection of sql statements.It is precompiled one so execution time is fast.Single name we can create procedure for insert,delete,update.
Triggers:
Mainly used for implementing business rules.It execute automatically when the particular event is fired. For example maximum record 100 if anybody try to insert after 100 then delete first come record(first come first out).
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is ISAM?
Can I use mariadb instead of mysql?
How to delete a trigger in mysql?
What are the advantages of myisam over innodb?
How to enable or disable a row of a table using MySQL in struts?
What are the 'mysql' command line options?
What is the phantom problem?
List some mysql advantages and disadvantages?
What is a deterministic function?
How to calculate the difference between two dates?
How to find second highest salary from a table?
How do I start mysql manually?
What is acid in mysql?
How do I stop a mysql command?
What are numeric data types?