User Profile
Collapse
-
I am learning data warehousing and analysis services as I am starting to think this may be the best approach. -
Query by date optimization
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...
No activity results to display
Show More
Leave a comment: