Re: performance of IN (subquery)

Greg Stark wrote:

> Ideally I would want a guarantee that every query would *always* result in the
> same plan. Once I've tested them and approved the plans I want to know that
> only those approved plans will ever run, and I want to be present and be able
> to verify new plans before they go into production.

What you are saying is "never run an ANALYZE" or if you do it you have to re-test
all your plans. "*always*" the same plan is a non sense because the plan depends on the
data distribution, do you test your plans for each given histogram slice ?

> I doubt I'm going to convince anyone today...

For sure not me.


Regards
Gaetano Mendola