How does DB2 use multiple table indexes?
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 |
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
Can you Average the Characters ?
Is db2 a programming language?
what is a plan and how do you refer the plan in the program?
Explain about cursor stability?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is a data page?
What is a buffer in memory?
Explain the benefits you can get from mainframe connect?
What are some SQL aggregates and other built-in functions?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Define db2 and its databases?