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
- 6653 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 |
Explain the contention situations caused by locks?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What is meant by AUTO COMMIT?
Define declaration generator (dclgen).
How to get Top 10 Salaries from a Table
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
what's the error code for Unique Index Violation?
pls explain the precompilation process of cobol-db2 pgm
What is a NULL value? What are the pros and cons of using NULLS?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What's The Percentage Free Space ?
COBOL 
