Thread: [GENERAL] Constraint exclusion involving joins

Hi, 
 

I understand that the constraints exclusion will work only on constant values. But in my case, I will never pass a constant value to the partitioning key when we query the partition table. Will the partition be still be beneficial in this case. If yes, can you please explain

Thanks