Re: Checking for the existence of a certain row.

[Ronald J Kimball]

On Mon, Jul 09, 2001 at 10:32:56AM -0700, Tim Harsch wrote:
> 
> > Regarding Oracle, it stops after the first row that matches.  I
> > tested this
> > on a table with 50 million rows, with a where clause that would select 20
> > million rows.  The query returned in seconds.  Here are the statistics:

[snip]

>       PS was your column indexed?

It was.  With a non-indexed column, as you might expect, the speed of the
query depends on how much of the table Oracle has to scan to find one that
matches.

Ronald