Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 use multiple table indexes?
- 1 Answers
- 5892 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 would you find out the total number of rows in a db2 table?
What is the difference between Primary key and unique index?
Write a query to retrive partial string.
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is the use of reorg in db2?
what is parm utility
can all users have the privilage to use the sql statement select * (dml)?
Describe the elements of the SELECT query syntax?
What is meant by index cardinality?
Explain dclgen.
What is the syntax for seeing the columns and data types of a table in the db2 database?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
COBOL 
