Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 use multiple table indexes?
- 1 Answers
- 5802 Views
- I also Faced
- E-Mail Answers
Answer / s
DB2 uses multiple index processing by using the technique
called list prefetch. The qualifying RIDS from all the
indexes in placed in the RID Pool, sorted and duplicate
RIDS are eliminated based on the page number and List
prefetch I/O issued to read the data pages in DASD
sequence.
| Is This Answer Correct ? | 2 Yes | 0 No |
what is Runstats? Whem will u choose to runatats?
What will the FREE command do to a plan?
When reorg is used?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
How to find primary key of a table in db2?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What does reorg do in db2?
What are some SQL aggregates and other built-in functions?
How can you classify the locks in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
COBOL 
