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
- 6669 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mention the different locking levels that are available in db2.
What is the syntax for FETCH in DB2 ?
What are the two types of logging in the db2 database? Explain them.
What does db2 stand for?
Can there be more than one cursor open for any program?
What is db2 connect?
what are bind concepts in db2 cobol?
What are db2 tables?
What are the contents of a dclmgen?
How does db2 sample database connect?
How to create db2 table in mainframe?
How many databases are there?
Mention the location where the output received from explain statement is stored.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Explain the contention situations caused by locks?
