All Forums Database
KVB 124 posts Joined 09/12
10 Dec 2014
Querying a partitioned table

Suppose there is less data in an already date partitioned table. Like,if we only have the last 3 months of data in the table will it perform faster during queries. When querying the tables they should both have the same partition on date and be queried with the same date range, which should be a sub selection of all the available dates-perhaps 1 week?
 
Thanks
KVB

You must sign in to leave a comment.