oracle - ORA-01795 - why is the maximum number of expressions limited to 1000 -

so total of work-arounds, i'm wondering historical reasons behind 1000 limit "maximum number of expressions" in in clause?

it might because, there potential of beingness abused tons of values. , every value in transformed equivalent or condition.

for illustration name in ('john', 'charles'..) transformed name = 'john' or name = 'charles'

so, might impact performance..

but note oracle still supports

select id emp name in (select name attendees)

in case, optimzer doesnt convert multiple or conditions, create join instead..

oracle

Four