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
- 6677 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 rct?
Where can you declare a cursor in a cobol-db2 program?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is drop table?
When do you use the IMAGECOPY?
What is sqlca?
Which isolation level provides maximum concurrency?
What is a db2 cursor?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
How will fetch last 5 rows from table in db2
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is tablespace?
COBOL 
