Re: A question about performance

>From: "Jerry Cunningham" <cunninghamjerry_at_visto.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: A question about performance
>Date: Wed, 21 Jun 2000 08:38:52 -0800
>
>Not necessarily.
>
>What if 99% of the records have subscr_id <= 0? Full table scan would be
>slower.

then case 1 and case 2 are not identical (case 2 returns less rows) and comparison is quite senseless, that's why everyone assumes there's no item with ID=0 and full table scan will be faster

    Marin

"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"