On 02/17/2012 08:00 AM, Sergei Petrunia wrote:
> Hi Timour,
>
> So, we're trying to fix this by making group-by-loose-scan access method be
> able to scan forwards (when evaluating MIN) and/or backwards (if evaluating
> MAX) until it finds a record that satisfies the WHERE condition.
>
> We stil
Hi Timour,
So, we're trying to fix this by making group-by-loose-scan access method be
able to scan forwards (when evaluating MIN) and/or backwards (if evaluating
MAX) until it finds a record that satisfies the WHERE condition.
We still need to determine whether we need to do the scan or index j
Hi Timour,
Feedback follows skype discussion:
First, here's a general comment
Consider a query:
SELECT b, min(a) FROM t1 GROUP BY b;
Suppose there is an index (b,a).
Loose scan would execute it as follows:
S00 h->index_first();
S01 produce an output record of (b, a) // first value o
3 matches
Mail list logo