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...


What is a composite index and how does it differ from a
multiple index?



What is a composite index and how does it differ from a multiple index?..

Answer / s

Composite index consists of two or more columns
A tablespace can have multiple indexes.
But the column to be indexed can only appear once in the
index

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB2 Interview Questions

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,


How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  


What is iseries database?

0 Answers  


Is db2 a mainframe database?

0 Answers  


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,


How is a typical db2 batch pgm executed?

0 Answers  


i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,


What can the SET option of the Repair Utility accomplish?

1 Answers  


What is reorg?

0 Answers  


What is a collection?

3 Answers  


Categories