Reply
Explorer
Posts: 99
Registered: ‎09-14-2016

query on partition question

Hi,

 

If i have a join on two tables A.id = B.id, and tables are partition by year/month, if i am sure they are in the same year/month, will add partition in the query help the performance

 

A.id=B.id and A.year=B.year and A.month=B.month

 

Thanks

Shannon

Announcements