Re: Q: Performance

>> 2. Are there performance differences between:
>> ---------------------------------------------
>> A. Select count(*) ...
>> B. Select count(rownum) ...
>> C. Select count('x') ....
>
>No.

I got the following timings when I tested it:

select count(*) from foobar 		Elapsed: 00:00:03.07
select count(1) from foobar		Elapsed: 00:00:03.74
select count(rownum) from foobar	Elapsed: 00:00:04.95

I got these numbers consistantly.

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com