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

How to resolve deadlock issue

20114


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1075


What is alias in db2?

1058


what is db2 restart?

2152


What types of tables are there in the db2 database?

1055


Define predicate?

1129


What is innodb buffer pool?

1050


What is cursor with hold option in db2?

1069


How can deadlocks be resolved?

932


Which isolation level provides highest data integrity?

1114


Which component is responsible for db2 startup and shutdown?

1033


How do I copy a table in db2?

998


What is the purpose of using commit?

1096


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

1039


What is isolation level in db2?

1001