Showing posts with label selection. Show all posts
Showing posts with label selection. Show all posts

Wednesday, March 7, 2012

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,