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>

"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

Original text of this message