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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null value in db2?

944


What type of database is db2?

906


What are the two types of logging in the db2 database? Explain them.

1016


Mention the definition of cobol in varchar field.

1176


What is the difference between using bind () and rebind () methods of naming class?

1324


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1027


Why do we bind in db2?

1137


Can you use max on a char column?

1026


What is cascading rollback?

1129


How to view db2 table structure?

959


What is data manager?

993


How can we retrieve the total number of records in RPG & CLLE?

577


What are host variables in db2?

989


What parameters are used to control the free space in DB2?

1004


What is the difference between drop table and delete table?

1116