Performance

In SQL Server 7, how would one improve selection
performance on a low cardinality column?
Thanks in advance,You might want to provide an example query and DDL to demonstrate exactly
what you want to do.
I assume you're talking about a simple where clause against a single column
when that column is low-cardinality?
Generally speaking... you'll find that a non-clustered index is not
effective for seeking on low cardinaility data. NC indexes tend not to be
helpful when anything more than a very low percentage of data in the table
is returned. You might find that a covered index (all the columns in the
query are in the index) might be helpful.
But a query and DDL example would be nice...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"RG" <anonymous@.discussions.microsoft.com> wrote in message
news:31a701c4a5a1$108e1080$a501280a@.phx.gbl...
> In SQL Server 7, how would one improve selection
> performance on a low cardinality column?
> Thanks in advance,