Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is check constraint. Explain with example.
What is access path in db2?
Explain in brief how does db2 determine what lock-size to use?
Explain how can you do the explain of a dynamic sql statement?
Explain correlated sub-queries.
Describe major components of db2?
Why do we need reorg in db2?
What is a page in db2?
How many types of page locks can be held in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is runstats and reorg in db2?
define clustering index.
What are concurrency issues?
What is dbrm in db2 database?
What is iseries database?
