Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 use multiple table indexes?
- 1 Answers
- 5698 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 |
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
Why do chiropractors use drop table?
What is package versioning? Please give an example.
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is an alias?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Which command is used to remove all rows from a table?
what is a plan and how do you refer the plan in the program?
i want to maintain uniqueness on pdf without make lf??????????
What is database reorganization?
What does the sqlcode of -818 pertain to?
What is the maximum size of varchar data type in db2?
COBOL 
