what is the advantage of stored procedures, triggers and
indexing in mysql
- 1 Answers
- 3686 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 'mysqlimport'?
What is mysql57?
Which software is used for mysql?
What is the function of mysqldump?
Where is the mysql data directory?
Is mariadb faster than mysql?
Where is the mysql config file?
How to Join tables on common columns.
Write a query to display even rows in student table using mysql?
How many columns can be used for creating Index?
How many threads can mysql handle?
What is database in php mysql?
What are date and time data types?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is text in mysql?
