I have a table that gets HUGE (250 MILLION records), the only thing that happens to this table is INSERT and SELECT.
Some of the searches by date appear to be slow, so we tossed around the idea of putting a NON CLUSTERED index on the data column. The date column is part of a composite key. RID+INSDATE is the primary key, so I know the insert date is already indexed.
Any suggestions why I should or should not?