My SQL is not performing well. Describe how will you fine
tune it?
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 to create a table using embedded sql?
how to resolve -811
What are the full forms of spufi and dclgen and why are they used?
Explain the use of the WHERE clause?
What is explain plan in db2?
How to handle null values in db2
How to resolve -917 sql code in DB2?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is ibm db2 database?
What is the role of the data page in the db2 database?
What are the contents of a dclmgen?