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