Partition on date question

Database

Partition on date question

I currently have several very large tables partioned on date (which is a month-end value) that only has a range until the end of this year.  My question is regarding extending the range.  Is there any performance change between extending say 2 years worth vs. 20 years worth?

 

Thanks,

Susan

1 REPLY
rjg
Supporter

Re: Partition on date question

Susan,

there should be no perfomance issue providing you collect statistics on partition for the tables and keep them current.

 

Rglass