Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

How does DB2 use multiple table indexes?

Question Posted / guest


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

Post New Answer

More DB2 Interview Questions

what is Static and dynamic linking

1 Answers   Virtusa,

What is the syntax for creating a table in the db2 database?

0 Answers  

Is db2 free?

0 Answers  

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

how to unload different table data into different gdg files/ vsam files.

3 Answers  

What does reorg do in db2?

0 Answers  

What is db2 catalog database?

0 Answers  

What is db2 optimizer?

0 Answers  

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,

What is IMAGECOPY ?

6 Answers  

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories