Interested to Buy Any Domain ? << Click Here >> for more details...
My SQL is not performing well. Describe how will you fine
tune it?
- 1 Answers
- 6668 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / akbar
Use EXPLAIN to list out the access paths of several
different codes you come up with and choose the path that
got executed within the least time.
| Is This Answer Correct ? | 4 Yes | 0 No |
How do I create a view in db2?
What is the use of db2 optimizer?
How to check sequence on a table in db2?
What is alias in db2?
What is Call attach facility? How does it work?
What is the function of logging in the db2 database?
How to execute stored procedure in db2 command editor?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
Can we insert update delete in view?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
Define check constraint.
COBOL 
