One of my tables includes a pair of Yes/No fields : [SoldFlag] and [ReturnedFlag]. There are a number of queries which use these flags to search for items which are (Sold) or which are (Sold and not Returned) for example. I am not aware of any performance issues with these queries.
Running the Performance Analyzer results in recommendations that both these fields should be indexed, whereas I was of the belief that it was generally not a good idea to index fields which had very few possible values. To add some numbers/context, the table has nearly 400,000 records, of which 30,000 are Sold and of those, 800 have been Returned.
Should I index or not ?
Running the Performance Analyzer results in recommendations that both these fields should be indexed, whereas I was of the belief that it was generally not a good idea to index fields which had very few possible values. To add some numbers/context, the table has nearly 400,000 records, of which 30,000 are Sold and of those, 800 have been Returned.
Should I index or not ?