What are the advantages of stored procedures, triggers,
indexes?

Answers were Sorted based on User's Feedback



What are the advantages of stored procedures, triggers, indexes?..

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

What are the advantages of stored procedures, triggers, indexes?..

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

What are the advantages of stored procedures, triggers, indexes?..

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

What are the advantages of stored procedures, triggers, indexes?..

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

What are the advantages of stored procedures, triggers, indexes?..

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

Post New Answer

More MySQL Interview Questions

How do I start mysql from command line?

0 Answers  


What is mysqli_connect_error ()?

0 Answers  


What is row level locking?

0 Answers  


Does uninstalling mysql delete database?

0 Answers  


How many columns can a mysql table have?

0 Answers  






what is the querry for all managers salary?

2 Answers  


Which statement is used in a select query for partial matching?

0 Answers  


What is mysql database used for?

0 Answers  


What is definer in mysql trigger?

0 Answers  


What are the differences between a primary key and foreign key?

0 Answers  


How to use 'mysql' to run sql statements?

0 Answers  


Is pdo faster than mysqli?

0 Answers  


Categories