Tommi Prami wrote:

>
>
> We have encontered into a weird problem. Some queries are like 10 times
> slower when Implemented as view. If query is run as is it is much
> faster. Is this an optimizer problem??
>
> This has been problem in 1.x and 1.5.x versions
>

The behavior depends on the type of view. Views with aggregates and
grouping are harder to merge into a query than simpler views. What
do your views look like?


Regards,


Ann