I've read the documentation on the MSDN, but it doesn't answer what I'm after. If I create an index on specified columns using a
WHERE clause for certain IDs, this will limit the index to those IDs and new IDs will insert into this index. That is all fine and dandy. But, in my
WHERE clause, I'd like to specify a list of previous IDs and also include anything that is greater than the highest ID in the table e.g.
WHERE CampaignID IN (1,2,10,14,16,20,26) AND CampaignID > 26
Is this advisable? The goal I'm trying to achieve is to index all of the data that is presently used, and ignore all other data. The table is over 10Gb and it's in constant use so I can't remove these old records as it locks the table and stops data being inserted.