Re: Using a field with low cardinality in a where clause.

From: Nabil Fanaian <nabil_fanaian_at_fe.ro>
Date: Wed, 27 Mar 2002 23:24:49 -0500
Message-ID: <a7u69a$47l$1@news-int.gatech.edu>

I start receiving records right away, which is what I want.

Well, seems like the only way around this problem was to get rid of the DISTINCT clause... I was finally able to get the DISTINCT out of the SQL stmt and now it performs great.

However, if you can think of a way to optimize the query using the DISTINCT, that would be even better.

Nabil.

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:uofh9us7i.fsf_at_rcn.com...
> On Wed, 27 Mar 2002, nabil_fanaian_at_fe.ro wrote:
> > However, if I remove the DISTINCT from my SQL statement, then the
> > query completes in milliseconds.
>
> Does it complete, or do you start recieving records right away? I'm
> guessing the latter.
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Wed Mar 27 2002 - 22:24:49 CST