adspace


What are the advantages of stored procedures, triggers,
indexes?

Answer Posted / riyas_isno

Triggers are used to identify changes (like insert,update
or delete) in database tables and captured in temp tables
seperately....it helps in business level logics...

procedures contains group of sql statements which are
precompiled ones.....

indexes helps in speedup our execution...

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is current version of mysql?

1084


Which statement is used in a select query for partial matching?

1247


What is the current mysql version?

1105


How to Change a users password from unix shell.

1223