Constraint exclusion involving joins

Started by Krithika Venkateshover 8 years ago1 messagesgeneral
Jump to latest
#1Krithika Venkatesh
krithikavenkatesh31@gmail.com

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