"Cyril VELTER" <cyril.velter@libertysurf.fr> writes:
> Is there a way for the optimizer to move the view "where" clause in the
> elementary union queries in order to use an index scan instead of the Seq
> scan ?
This is on the "to look at" list. It's not immediately clear to me
whether there are any restrictions on when the system can safely make
such a transformation, nor whether there are cases where it would be
a pessimization rather than an optimization.
regards, tom lane