Hi!
What do you think about "learn" optimizer to use indices
in queries like:
select max(i) from tab;
Currently, even if "i" have *unique* index, value for max()
is searched sequentially!
And one more:
select * from tab where (s ~ '^aa');
In this case, if "s" indexed, why not use index, since we know
*first* characters, and can limit search range?
/Al
------------------------------