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

Home -> Community -> Mailing Lists -> Oracle-L -> A question about performance

A question about performance

From: J <TiffanyDu_at_pcdc.com.tw>
Date: Wed, 21 Jun 2000 10:22:29 +0800
Message-Id: <10534.109931@fatcity.com>

	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 Tue Jun 20 2000 - 21:22:29 CDT

Original text of this message

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