Re: Speed up query
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sat, 11 Oct 2008 20:02:42 +0200
Message-ID: <48f0ea43$0$197$e4fe514c@news.xs4all.nl>
Date: Sat, 11 Oct 2008 20:02:42 +0200
Message-ID: <48f0ea43$0$197$e4fe514c@news.xs4all.nl>
"Maxim Demenko" <mdemenko_at_gmail.com> schreef in bericht
news:48F086B4.6060909_at_gmail.com...
> Shakespeare schrieb:
>> On second thoughts: I don't think you need the md table at all....since
>> A) you don't select anything from it and
>> B) all join conditions are either hard coded or fullfilled by other
>> tables.
>>
>> So the only result by adding md could be returning some duplicate rows.
>
> I don't think that is correct assumption ( without knowing the data
> model) - adding a table to join may equally well restrict the result set.
>
> Best regards
>
> Maxim
Darn, you're right (as always).
Shakespeare Received on Sat Oct 11 2008 - 13:02:42 CDT