Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-11 : 10:09:47
|
| Janine writes "I am querying a large table based upon a status column, such that my query only ever returns 1% of the data. However, since a couple of the status values represent about 80% of the data, creating an index on status is doing no good. Any suggestions as to how to get decent response time and prevent doing a table or clustered index scan? (The index by status is non-clustered, but the clustered index should remain on the other columns that it's already built over)." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-11 : 10:31:24
|
quote:
but the clustered index should remain on the other columns that it's already built over
And those columns are...?If you post your table structure, which columns are indexed (especially the clustered index), and the queries that you run against this table, we'll have a chance in hell of helping you out. |
 |
|
|
|
|
|
Query of large table - index creation hints