what is the advantage of stored procedures, triggers and
indexing in mysql
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
How do I start mysql manually?
Is null in mysql?
How can you export the table as an xml file in mysql?
What are the indexes in mysql?
How do you connect MySQL database with PHP?
What is the difference between unix timestamps and mysql timestamps?
How do I install mysql?
What is MySQL?
What causes mysql too many connections?
Who owns mysql database?
What are the differences between a primary key and foreign key?
What is RMS Migrations
What are the limitations of mysql?
How do I connect to a database in mysql workbench?
How show all tables in mysql query?