EXPR_STR: select c1 from t3 where c1 like '|||%'; SELECTIVITY = 0.000100072 EXPR_STR: select c1 from t3 where c1 like '11'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 > '|||||||||||||||||||2'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 = '11'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 != '11'; SELECTIVITY = 0.9999 EXPR_STR: select c1 from t3 where c1 > '11'; SELECTIVITY = 0.986844 EXPR_STR: select c1 from t3 where c1 < '11'; SELECTIVITY = 0.0131557 EXPR_STR: select c1 from t3 where c1 < '|||||||||||||||||||2'; SELECTIVITY = 1 EXPR_STR: select c1 from t3 where c1 > '|||||||||||||||||||2'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 > '||||||||||||||||||||'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 > '20150305123445555'; SELECTIVITY = 0.974024 EXPR_STR: select c1 from t3 where c1 > '20150305123445555'; SELECTIVITY = 0.974024 EXPR_STR: select c1 from t3 where c1 like '11'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 like 'abc'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 like '|||%'; SELECTIVITY = 0.000100072 EXPR_STR: select c1 from t3 where c1 like 123; SELECTIVITY = 0.333333 EXPR_STR: select c1 from t3 where c1 like 's%123' escape 's'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 like '123'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 like '%123'; SELECTIVITY = 0.333333 EXPR_STR: select c1 from t3 where c1 like '%%'; SELECTIVITY = 0.333333 EXPR_STR: select c1 from t3 where c1 like '%||||%'; SELECTIVITY = 0.333333 EXPR_STR: select c1 from t3 where c1 like '%|||'; SELECTIVITY = 0.333333 EXPR_STR: select c1 from t3 where c1 > '20150305123445555'; SELECTIVITY = 0.887209 EXPR_STR: select c1 from t3 where c1 < '20150305123445555'; SELECTIVITY = 0.112791 EXPR_STR: select c1 from t3 where c1 < '99991231235959999'; SELECTIVITY = 1 EXPR_STR: select c1 from t3 where c1 > '99991231235959999'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 < '10000101000000111'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 > '10000101000000111'; SELECTIVITY = 1 EXPR_STR: select c1 from t3 where c1 > '10000101000000111' and c1 < '99991231235959999'; SELECTIVITY = 0.9999 EXPR_STR: select c1 from t3 where c1 > '20150305123445555' and c1 < '10000101000000111'; SELECTIVITY = 0 EXPR_STR: select c1 from t3 where c1 < '20150305123445555' and c1 > '99991231235959999'; SELECTIVITY = 0 EXPR_STR: select c1 from t3 where c1 > '20150305123445555' and c1 < '50120805123445666'; SELECTIVITY = 0.332938 EXPR_STR: select c1 from t3 where c1 > '20150305123445555' and c1 < '20150305123446666'; SELECTIVITY = 0 EXPR_STR: select c1 from t3 where c1 = '20150305123445555'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 != '20150305123445555'; SELECTIVITY = 0.9999 EXPR_STR: select c1 from t3 where c1 like '20150305123445555'; SELECTIVITY = 0.0001 EXPR_STR: select c1 from t3 where c1 like '1000%'; SELECTIVITY = 0.000100007 EXPR_STR: select c1 from t3 where c1 like '9999%'; SELECTIVITY = 0.000100002 EXPR_STR: select c1 from t3 where c1 like '1%'; SELECTIVITY = 0.0994233 EXPR_STR: select c1 from t3 where c1 like '99%'; SELECTIVITY = 0.000223633