Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of stored procedures, triggers,
indexes?
- 5 Answers
- 33564 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit joshi
Advantages of Triggers
Triggers are basically the statements that are executed
automatically after any of the DML operation.
Its basic advantage is that we dont need to invoke it again
and again it will be created once and serve us for the rest
of time.
Triggers are not invoked from the Application end rather it
will be invoked from the Database Management System.
Triggers are used to simply make a look on any of the
activity going on the client side.
Advantages of Stored Procedured:
Stored procedured are the precompiled statements and one of
its biggest advantage is that it speed up the performance
of our application.
| Is This Answer Correct ? | 35 Yes | 8 No |
Post New Answer View All Answers
Why we use mysqli instead of mysql?
What is delimiter in mysql stored procedure?
What is the hostname for mysql database?
What is a user defined variable?
What is triggers and how it can be used in mysql?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
How do I create a mysql database?
How do you use auto increment?
What are ddl statements in mysql?
How can you take the backup and restore a mysql database using php?
How do I show columns in mysql?
What are the functions used to encrypt and decrypt the data present in mysql?
What is the purpose of using timestamp data type?
How do I copy an entire mysql database?
Can we join 3 tables in mysql?
