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 |
What are CSV tables?
Is mysqli faster than mysql?
How do you start MySQL on Linux?
Explain % and _ inside like statement?
How do I select a database in mysql?
is it possible to assign two primary key in a table
List the different types of normalization?
What is a csv table?
How to connect html form to mysql database using php?
Write a query to retrieve a hundred books starting from 20th.
What is mysql port?
What do we use to remove duplicate records while fetching a data in mysql ?