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: Queries give impossible results

Re: Queries give impossible results

From: Jake S <nospam_at_nospam.net>
Date: Thu, 14 Nov 2002 12:20:32 GMT
Message-ID: <kyMA9.182$ZR5.5926@read2.inet.fi>


> > Have you done a select * instead of a select count(*) and got more than
4
> > records in your final example?
> >
>
> Yes I have. I've also tried all the possible combinations with this query.
>

The answer was: yes, I've done that and no, I only get 4. I'm thinking that indexes might be the problem.

Received on Thu Nov 14 2002 - 06:20:32 CST

Original text of this message

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