Querying a partitioned table

Database
KVB
Enthusiast

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