Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 use multiple table indexes?
- 1 Answers
- 5888 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 query_cache_limit?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What action db2 takes when a program aborts in the middle of a transaction?
What is COPY PENDING status?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What language is db2 written in?
What is the maximum number of columns in a db2 table?
What is the meaning concurrency in the db2 database?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is db2 stogroup?
What is cursor stability?
What are the full forms of spufi and dclgen and why are they used?
COBOL 
