what is the advantage of stored procedures, triggers and
indexing in mysql
Answer / 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 |
What is trigger in mysql with example?
Is mysql owned by oracle?
What is mysql database server?
How much does mysql cost?
How many columns can be used for creating Index?
Is mysql same as mariadb?
What happens if a table has one column defined as TIMESTAMP?
about join
How do I flush privileges in mysql?
How can you export the table as an xml file in mysql?
How do I create a database in mysql workbench?
What is the use of mysqli_num_rows?