Re: BUG #5652: Optimizer does wrong thing with partitioned tables

Mladen Gogala escreveu:
> Optimizer chooses to scan each partitioned table sequentially, instead of
> using the available index:
>
This is not a bug. How would the optimizer know that the maximum value is in
that specific partition? There is neither a global index for a partitioned
table nor an optimizer artifact to know aggregate information before scanning
all of the partitions. Maybe when we have a better support for table
partitioning such optimizer artifact would be implemented but don't hold your
breath.


--
  Euler Taveira de Oliveira
  http://www.timbira.com/