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