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

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


Can a Db2 table data be retrived through JCL?

4 Answers  


What is isolation level in db2?

0 Answers  


My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,


what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


What is a thread?

3 Answers  


For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,


What is filter factor?

2 Answers  


How do I change the column size in db2?

0 Answers  


What does db2 blu stand for?

0 Answers  


Categories