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
Is mysql a relational database?
How to use sum function in where clause in mysql?
What is database clustering in mysql?
When to use order by in delete statement?
What is the difference between mysql and pdo?
How much does mysql enterprise cost?
How to delete a table.
I want to start and stop mysql on windows? How do I do that?
Is mysql is a programming language?
Who owns mysql database?
How to use mysqldump to create a copy of the database?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What is foreign key in mysql?
What is normalization and list the different types of normalization?
How to use in conditions?