Re: Speed up query
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 11 Oct 2008 12:57:56 +0200
Message-ID: <48F086B4.6060909@gmail.com>
Date: Sat, 11 Oct 2008 12:57:56 +0200
Message-ID: <48F086B4.6060909@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 Received on Sat Oct 11 2008 - 05:57:56 CDT