Interested to Buy Any Domain ? << Click Here >> for more details...
what is the advantage of stored procedures, triggers and
indexing in mysql
- 1 Answers
- 4617 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 difference between schema and table?
How to create a table index in mysql?
How many rows we can insert in a mysql table?
What are the disadvantages of mysql?
In how many ways we can retrieve data in the result set of mysql using php?
Describe mysql transaction properties.
How to calculate expressions with sql statements?
How do you use auto increment?
What is the difference between the primary and unique key in mysql?
Is mysql relational?
How to create a table?
Is mysql written in c?
What are mysql data types?
What is blob and clob?
Is mysql open source?
