Interested to Buy Any Domain ? << Click Here >> for more details...
what is the advantage of stored procedures, triggers and
indexing in mysql
- 1 Answers
- 4520 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 storage engines are used in MySQL?
How to get a list of columns in an existing table?
How do I optimize a selected query in mysql?
How do I insert an image into mysql workbench?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How do I completely remove mysql from windows?
Is mariadb faster than mysql?
What data structure does mysql use?
What does mysql flush privileges do?
Can you tell how many values can set the function of mysql to consider?
What is mysqlcommand?
What is unsigned in mysql?
How to create a new table by selecting rows from another table in mysql?
What is pragma exception?
How to include numeric values in sql statements?
