Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What do you understand by mysql terminal?

984


How do I restore a database in mysql workbench?

925


Which datatype is used for email in mysql?

909


What are mysql queries?

878


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2429


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

882


What is sql in mysql?

983


What is ndb in mysql?

906


What does schema mean?

877


What is root password?

849


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2168


What is difference between pdo and mysqli?

914


Why to use char instead of varchar in the database?

1093


What does mysql workbench do?

812


What is the current root password of mysql?

859