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

What is with ur in db2?

1326


How would you find out the total number of rows in a db2 table?

1057


can we view the access paths created by dbrm ? how ? thx

7104


What types of tables are there in the db2 database?

1061


What is check constraint in db2?

1095


What type of database is db2?

973


What is explain in db2?

1036


What is dbrm?

1112


What is syscat in db2?

1020


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1111


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9223


What is sqlca?

1083


How do I add a column in db2?

1053


What are bind parameters in db2?

1051


What is db2 look?

1031