Interested to Buy Any Domain ? << Click Here >> for more details...
what is the advantage of stored procedures, triggers and
indexing in mysql
- 1 Answers
- 4694 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is mysql common?
How do I rename a mysql database?
Is mysql an oracle product?
How do I restore a mysql database dump file in linux?
What is required to create mysql database?
What port is mysql running on?
What is the maximum number of records in mysql table?
What is not null in mysql?
What is ibdata1?
How to copy data from one server to another using php?
How to enter boolean values in sql statements?
In mysql, what is the default storage engine?
What is the data source name for mysql?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
what is the difference between between and in operators in mysql?
