what is the advantage of stored procedures, triggers and
indexing in mysql



what is the advantage of stored procedures, triggers and indexing in mysql..

Answer / lijo

SP's Stored procedures in simple words is a complied SQL
stt. where there is no need for compiling it again on
successive calls.

Trigger is mechanism to handle insert/update.., like
operation happening in database.

Index are used for searching where searching a indexed data
takes less time while comparing with un-indexed.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More MySQL Interview Questions

What are CSV tables?

1 Answers  


Is mysqli faster than mysql?

0 Answers  


How do you start MySQL on Linux?

5 Answers   Cybernet,


Explain % and _ inside like statement?

0 Answers  


How do I select a database in mysql?

0 Answers  






is it possible to assign two primary key in a table

8 Answers   IBM,


List the different types of normalization?

0 Answers  


What is a csv table?

0 Answers  


How to connect html form to mysql database using php?

0 Answers  


Write a query to retrieve a hundred books starting from 20th.

0 Answers  


What is mysql port?

0 Answers  


What do we use to remove duplicate records while fetching a data in mysql ?

0 Answers  


Categories