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 index cardinality?

Answer Posted / uday

According to what i have observed, cardinality is the number
of count of nodes in the BTree of respective index.

If you create a table with with name attribute and inserted
into 100 new names and added and index.

then if you see the cardinality, certainly it wont be 100.
it will be some thing less than 100.

thats it....

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster delete or truncate?

1081


What is null indicator in db2?

1061


What is the clustering index in the db2 database?

966


What is runstats db2?

975


What is lock escalation in db2?

979


B37 abend during spufi?

1418


How do I import data from excel to db2?

1029


What is dbrm in db2 database?

1052


What is cursor with hold option in db2?

1027


What is catalog database in db2?

1116


How many types of page locks can be held in db2?

1002


What are the contents of a dclmgen?

1082


Is db2 a mainframe database?

959


Is the primary key a clustered index?

1091


What do you mean by commit and rollback?

992