Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using a field with low cardinality in a where clause.

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

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 27 Mar 2002 21:19:23 -0600
Message-ID: <uofh9us7i.fsf@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 - 21:19:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US