Subject Re: [firebird-support] Optimizing SELECT DISTINCT ..
Author Harriv
On Tue, Feb 3, 2009 at 1:26 PM, Dimitry Sibiryakov <sd@...> wrote:
>> What would be best way to optimize "SELECT DISTINCT FIELD1 FROM
>> TABLE1 ORDER BY FIELD1" query?
>
> Normalize DB structure to 3rd form.

Yes, I was thinking that, and i might have to do that because of
other requirements. I was just wondering if there's available somekind
of first aid to this problem.

>
> SY, SD.
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>