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.

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.

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.

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).

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...

What different Stored Objects are supported in MySQL?

1 Answers  

what is the difference between between and in operators in mysql?

0 Answers  

What is full form of xampp?

0 Answers  

What are the types of queries?

0 Answers  

What is view? How can you create and drop view in mysql?

0 Answers  

Explain triggers and stored procedures?

0 Answers  

How do I start mysql client?

0 Answers  

What is the storage engine used for MySQL?

1 Answers  

Can foreign key have duplicate values?

0 Answers  

What is row locking in mysql?

0 Answers  

How to check if a record exists in a mysql database php?

0 Answers  

What is delimiter $$?

0 Answers