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
- 6591 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 |
What does runstats do in db2?
What is the use of value function?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is meant by the attachment facility?
How can we read records for specific member in CL? AND rpg?
Which catalog table stores referential constraints?
What does the REORG Utility do?
Can we install 2 different versions of Db2 on same mainframe?
What is pagespace?
What is iseries database?
What is a plan and package in db2?
COBOL 
