Home » RDBMS Server » Performance Tuning » full table scan
full table scan [message #65306] Wed, 28 July 2004 20:54 Go to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
Dear All,

While using

TO_NUMBER(TO_CHAR(START_DATE,'YYYY'))) < :V_ACC_YEAR)


it is causing a full table scan, resulting in slow performance.

CAn you please let me know, how it can be eliminated or what is the alternative?

I have an index on start_date.

Regards,

Jay.

Report message to a moderator

Re: full table scan [message #65309 is a reply to message #65306] Thu, 29 July 2004 05:25 Go to previous messageGo to next message
shoblock
Messages: 325
Registered: April 2004
Senior Member
TO_NUMBER(TO_CHAR(START_DATE,'YYYY'))) < :V_ACC_YEAR)

start_date < to_date('0101'|| :v_acc_year,'ddmmyyyy')

Report message to a moderator

Re: full table scan [message #65323 is a reply to message #65309] Tue, 03 August 2004 18:01 Go to previous message
IA
Messages: 91
Registered: March 2004
Member
I agree.

Report message to a moderator

Previous Topic: shared pool
Next Topic: which is the best tool to analyse
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 19:42:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.