Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 use multiple table indexes?
- 1 Answers
- 5788 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 |
How to create db2 table in mainframe?
What is the maximum No of rows per page?
What is a collection in db2?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What is dclgen (declaration generator)?
What is load replace in db2?
what is dynamic cursor?gives syntax for this?
How do I change the column size in db2?
how can u retrieve the data from null values using applicaion program.
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is load utility in db2?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
COBOL 
