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
- 6749 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 is the advantage in De-normalizing tables in DB2?
What is the size of a data page?
What's the maximum number of characters that a tablename can have?
What is data manager?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
can we view the access paths created by dbrm ? how ? thx
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What is meant by isolation level?
What is the use of reorg in db2?
what is + sign and -ve sign for sql code ?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
COBOL 
