OraFAQ Forum: Performance Tuning » Going for full table scan

Home » RDBMS Server » Performance Tuning » Going for full table scan (Oracle 10G /Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Going for full table scan [message #382608]

Fri, 23 January 2009 03:55

dhanamukesh
Messages: 51
Registered: January 2009

Member

I couldn't able to reduce the cost of this query.I found that one of the table ds_transaction is oging for full table scan.I tried with indexed column also.but still the cost is high going for full table scan.

I have attached the supporting documents with this.

Please help me out with this query.

Regards,
Dhanalakshmi.P

Attachment: aacuc6ma56kqy.sql
(Size: 0.67KB, Downloaded 1066 times)

Report message to a moderator

Re: Going for full table scan [message #382610 is a reply to message #382608]

Fri, 23 January 2009 03:58

dhanamukesh
Messages: 51
Registered: January 2009

Member

here i have attached the explain plan for the query.

Attachment: aacuc6ma56kqy.jpg
(Size: 191.13KB, Downloaded 720 times)

Report message to a moderator

Re: Going for full table scan [message #382817 is a reply to message #382608]

Sun, 25 January 2009 05:39

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Try:

1. CREATE INDEX ... ON DS_TRANSACTION ( TRAN_STAT_CODE , TRAN_STAT_DATE ) ...

2. Change the statement:

...
   AND DT.TRAN_STAT_DATE BETWEEN :B4 AND :B3
   AND DT.TRAN_STAT_CODE = :B2 ...

HTH.

Report message to a moderator

Re: Going for full table scan [message #383012 is a reply to message #382817]

Mon, 26 January 2009 23:52

dhanamukesh
Messages: 51
Registered: January 2009

Member

Thanks a lot.

Report message to a moderator

Previous Topic:	How to tune
Next Topic:	Not able to reduce the optimizer cost after creating index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 00:39:54 CDT 2024