Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of stored procedures, triggers,
indexes?
- 5 Answers
- 33557 Views
- I also Faced
- E-Mail Answers
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
What are the advantages of a procedure?
What are the differences between char and varchar data types?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
What is index length in mysql?
What does schema mean?
How to get a version of mysql?
What are the two types of queries?
How can you change the name of any existing table by using the sql statement?
What is the purpose of -> in the mysql terminal?
Is mysql good for big data?
Can you tell the difference between $message and $$message?
What happens if null values are involved in expressions?
How can we run batch mode in mysql?
What mysql -u john -p command does?
How to Change a users password from unix shell.
