Home » SQL & PL/SQL » SQL & PL/SQL » Re: Verifying if the data(one row) fulfilling a select criteria exists in the table or not
Re: Verifying if the data(one row) fulfilling a select criteria exists in the table or not [message #20586] Wed, 05 June 2002 21:44
eela
Messages: 7
Registered: June 2002
Junior Member
Thanks,

I checked for the performance gain over using count(*) . If count(*) takes 1 sec (count was somewhere around 7610) then rowmun < 2 takes around 400 msec. Do u have any idea why performance gain is not as expected . For this query only one record is to traversed so why is it taking long ?

thanks
Previous Topic: Re: PL/SQL Program Constructs
Next Topic: Re: PL/SQL Program Constructs
Goto Forum:
  


Current Time: Sun Nov 18 02:10:05 CST 2018