What are the advantages of stored procedures, triggers,
indexes?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ankit joshi
Advantages of Triggers
Triggers are basically the statements that are executed
automatically after any of the DML operation.
Its basic advantage is that we dont need to invoke it again
and again it will be created once and serve us for the rest
of time.
Triggers are not invoked from the Application end rather it
will be invoked from the Database Management System.
Triggers are used to simply make a look on any of the
activity going on the client side.
Advantages of Stored Procedured:
Stored procedured are the precompiled statements and one of
its biggest advantage is that it speed up the performance
of our application.
Is This Answer Correct ? | 35 Yes | 8 No |
Answer / manish jha
Triggers are automatic executable statement.
A stored procedure is a set of SQL commands that has been
compiled & stored on the database server.
Indexs hepls to execute queries fast.
Is This Answer Correct ? | 20 Yes | 7 No |
Answer / 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 |
Answer / 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 |
How many rows can be inserted in mysql at a time?
What do you need to connect php to mysql?
What is mysql port?
How do I connect to mysql database?
What is mysqlcheck do?
How to shut down the server with 'mysqladmin'?
What data type is money?
What is dump in mysql?
what is cte? : Mysql dba
How do I assign a variable in mysql?
How many rows can a mysql table hold?
What is flush privileges in mysql?