Recently I was trying to add a new index on a table that has more than 256 columns (I know I know, that is too many columns... I inherited the table and am working on a new database design). I am running SQL Server 2000 Back to the issue. While trying to add the new index I got the following message: Error 1910 - Cannot create more than 256 nonclustered indices or column statistics on one table. I checked the indexes on the table and only saw two. Then I queried the sysindexes table and saw 256. Most of them were WA_SYS indexes. I read up on the WA_SYS indexes and found they are created automatically by SQL Server for optimization statistics. Do I really need these? Will they eventually hurt performace? I deleted the WA_SYS indexes from the sysindexes table for this one table. However I have other tables with many columns and I am considering doing the same. Would this be beneficial or does it not matter? FYI most of the columns on these large table are defined as CHAR(1). Some hack created these tables and we are trying to redesign. But in the meantime I want to increase performance as much as possible.