Svein,

Magnificant, I'm not sure why I didn't think of doing that. Works like a
charm, too.

-Mark

-----Original Message-----
From: Svein Erling Tysvar
[mailto:svein.erling.tysvaer@...]
Sent: Tuesday, July 02, 2002 3:04 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Select joined with a view is slow


Mark,

>select v_peoplepicturescount.*
>from people sel_people
>left join v_peoplepicturescount on v_peoplepicturescount.pid=sel_people.pid

why do you do a left (outer) join here? The view itself already contains a
left join for the people table, so it will match every occurence. I don't
know if it will help any, but changing to

select v_peoplepicturescount.*
from people sel_people
join v_peoplepicturescount on v_peoplepicturescount.pid=sel_people.pid

should yield the same result.

Set

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/