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
- 6750 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
How can the duplicate values be eliminated from db2 select?
What is db2 look?
What is the role of data manager in the db2 database?
Which command is used to remove all rows from a table?
What is dbrm? When it will be created?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to fetch the last row from the table in SQL (db2)?
What is db2 purescale?
Which component is responsible for processing sql statements and selecting access paths?
What is rebind in db2?
How to access db2 tables in mainframe?
What are iseries servers?
What is the syntax for FETCH in DB2 ?
Explain correlated sub-queries.
List out the data types available.
