Hi I'm baffled by this one. I have put an index on one column. When I query the table using the indexed column in the where clause it does not use the index(slow). If I put "(index=ix_tbl_col) where col = 2 " it does Correctly use the index and is much faster. I've run dbcc checkdb, up...more >>