What is access path in db2?
- 0 Answers
- 637 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
What is the default page size of buffer pools?
Describe the elements of the SELECT query syntax?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is view db2?
How many types of page locks can be held in db2?
what is the use of cursors?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is REORG? When is it used?
Give the COBOL definition of a VARCHAR field.
What else is there in the PLAN apart from the access path?
What is a Resource Control Table(RCT)? Describe its characteristics.
COBOL 
