t;[EMAIL PROTECTED]>
Cc: "Ratheesh K J" <[EMAIL PROTECTED]>;
Sent: Friday, August 04, 2006 1:31 PM
Subject: Re: Another question on Cardinality??
Brent,
Given that...
You really have to match cardinality with distribution of values.
...sounds like hard work (well you act
Brent,
Given that...
You really have to match cardinality with distribution of values.
...sounds like hard work (well you actually have to think about it) and...
considering all the above cases, what should I conclude? should I have
indexes on these three fields?
Looking for a specific answe
]>
To:
Sent: Friday, August 04, 2006 6:15 AM
Subject: Another question on Cardinality??
Hello all,
Another question on cardinality.
Consider a table with 1000 rows and columnns. Details of the columns are as
below:
FLD_1 - int - cardinality 1000 - PRIMARY KEY
FLD_2 - tinyint- cardinal
Have you considered reading up on basic database management?
There are plenty of good material on the web for you to read where you
can actually learn how to manage databases, so you don't have to ask
others about every single detail.
Ratheesh K J wrote:
Hello all,
Another questi
Hello all,
Another question on cardinality.
Consider a table with 1000 rows and columnns. Details of the columns are as
below:
FLD_1 - int - cardinality 1000 - PRIMARY KEY
FLD_2 - tinyint- cardinality 400
FLD_3 - varchar - cardinality 10
FLD_4 - varchar - cardinality 2
FLD_5 - varchar
