Re: Slow execution time when querying view with WHERE clause

Mike Mascari wrote:
> I have the following view:
>
> create or replace view market.p_areas as
> select a.*
> from _areas a
> where a.area in (
> select b.area
> from _bins b, _inventories i, _offers o, _pricemembers p
> where b.bin = i.bin and
> i.inventory = o.inventory and
> o.pricegroup = p.pricegroup and
> p.buyer in (
> select s.store
> from _stores s, _webusers w
> where w.webuser = getWebuser() and
> w.company = s.company
> union
> select s.store
> from _stores s, _companies c
> where s.company = c.company and
> c.companyid = 'DEFAULT'
> )
> );

...

I failed to report the version:

select version();

PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3.4.0 20040204 (prerelease)

Sorry.

Mike Mascari