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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Indexing tables

Author  Topic  Rockn Starting Member 10 Posts Posted - 2001-10-12 : 14:00:12 Are there any fields that should not be indexed...i know there are some that cannot because of the datatype. Our developer never indexed any of the fields included in his WHERE clauses. I indexed al of them and the response time has shot up 3 fold at least. Any advice? TIA Edited by - Rockn on 10/12/2001 14:06:46