RE: A question about performance

I think performance will be about the same. You select all records in the table, no matter which statement you use. So evidently, Oracle will process every row no matter what.

Greets,

Kirsten

> -----Original Message-----
>
> Hi All:
> There is a question about performance.
> Table name : subscriber , primary key : subscr_id , with
> over 5000000 records .
>
> CASE 1 : select *
> from subscriber ;
> (FULL TABLE SCAN)
>
> CASE 2 : select *
> from subscriber
> where subscr_id > 0 ;
> (USE INDEX)
>
> Could anyone tell me which ones performance is better , or
> they are the same ??
>
> Thank you in advance.
>
>
> Tiffany
> E-mail tiffanydu_at_pcdc.com.tw
Received on Wed Jun 21 2000 - 06:43:06 CDT