Re: [ADMIN] Query optimization path

2003-01-12 Thread Bruno Wolff III
On Sun, Jan 12, 2003 at 18:07:14 +0100, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > "Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message > > > Using "JOIN" fixes the order that tables are joined in. If you are > > just doing inner joins, then you probably don't want to use the "JOIN" > > keyw

Re: [ADMIN] Query optimization path

2003-01-12 Thread Stephan Szabo
On Sun, 12 Jan 2003, Gaetano Mendola wrote: > "Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Gaetano Mendola <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > I have the following query: > > > > > > SELECT count(1) > > > FROM provider

Re: [ADMIN] Query optimization path

2003-01-12 Thread Gaetano Mendola
"Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Gaetano Mendola <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I have the following query: > > > > SELECT count(1) > > FROM providers p JOIN class_default cdUSING (id_provider) > >

Re: [ADMIN] Query optimization path

2003-01-12 Thread Bruno Wolff III
On Sun, Jan 12, 2003 at 17:31:34 +0100, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > Hi all, > > I have the following query: > > SELECT count(1) > FROM providers p JOIN class_default cdUSING (id_provider) > JOIN user_data udUSING (id_class) > JOIN v

[ADMIN] Query optimization path

2003-01-12 Thread Gaetano Mendola
Hi all, I have the following query: SELECT count(1) FROM providers p JOIN class_default cdUSING (id_provider) JOIN user_data udUSING (id_class) JOIN v_user_traffic ut USING (id_user) WHERE id_user_status in (4,5) AND p.company = 'X'; is n