Hi
*Edit* I ran some tests and wanted to edit my question. Basically I just would like to know:
If I have an date field as part of a multicolumn primary key, would it be best to create a nonclustered index on just the invoice date field?
There are 760 million records and the result set is one week worth of data - 150,000 records.
Looking for the best practice. The data is historical and is never modified.