What are the advantages of stored procedures, triggers,
indexes?
Answer Posted / kalai
1.Advsntsge of Stored Procedures:
================================
Stored Procedures are precompiled one.
it is the group of sql statements.
stored procedure like a application programming.
stored procedure is a fast one because it is already
precompiled.
stored procedure is the one is easy to maintain.
2.Advantage of Triggers:
========================
Triggers is a special kind of procedure.
the Main advantage of the trigger is automatic.
whenever the table affected by insert update or delete
query that time the triggers will implicitely call.
3.Advantage of Indexs:
======================
The Main advantage of the indexes is speed.
if the table having the indexes while selecting or
filtering the row(s) 0r columns(s) ,the execution time
very fast.
but, if you use the indexed table the insert update and
delete will be slow.
Is This Answer Correct ? | 88 Yes | 12 No |
Post New Answer View All Answers
How do I edit a stored procedure in mysql?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What is the difference between sql and mysql and oracle?
How do I install mysql?
What are the three types of queries?
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
Is sqlite faster than mysql?
Which is better mysql or microsoft sql?
How to use case expression?
Why mongodb is faster than mysql?
What does blob mean in mysql?
Is mysql owned by oracle?
How do I remove a user from mysql?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
Can mysql handle big data?