tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Atri Sharma <atri.j...@gmail.com>
Subject Optimization around Multiple ORs and constants
Date Wed, 15 Jul 2015 17:36:59 GMT
Hi,

For cases like WHERE col1=val1 OR col1=val2 OR col1=val3 OR col1=val4 OR
col1=val5 where val1,val2,val3,val4,val5 are constants, do we do any
optimizations? I can imagine conversion to IN(val1,val2,val3,val4,val5)
which will be more optimized.

-- 
Regards,

Atri
*l'apprenant*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message