What are the advantages of stored procedures, triggers,
indexes?
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
How can we change the data type of a column of a table?
Write a query to create a database and a table?
Why we use mysql database?
What is maximum table size in mysql?
How can you make a database as your current database?
How can I see mysql database?
How do you say mysql?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
How do I set user privileges in mysql?
Is mariadb better than mysql?
How to use regular expression in pattern match conditions?
How to rename an existing column in a table?
How do I make an action query?
How to rename an existing table in mysql?
How to calculate the difference between two dates?