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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 11:04:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.