Home » SQL & PL/SQL » SQL & PL/SQL » IO cost is high (Oracle 10G /Linux)
IO cost is high [message #400654] Wed, 29 April 2009 04:03 Go to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Please find the below query and help me out to improve the performance of the query.


The cost of the query will be 26123 and CPU Cost is 4396885077
and io cost is 25964

select * from ofac_exception_source t
where t.exception_state_code <> 3
and t.product_code = 'CP'


Regards,
Dhanalakshmi
Re: IO cost is high [message #400689 is a reply to message #400654] Wed, 29 April 2009 05:10 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I had a miserable day. Thanks for the laughs.

You are a funny guy!
Re: IO cost is high [message #400716 is a reply to message #400654] Wed, 29 April 2009 06:17 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous post:
BlackSwan wrote on Fri, 27 March 2009 07:00
Did you read & follow the bouncing RED ball advice as stated in URL below?
http://www.orafaq.com/forum/f/1/136107/
Did you read & follow Posting Guidelines as contained in URL below?
http://www.orafaq.com/forum/t/88153/0/

Another one:
gentlebabu wrote on Thu, 26 February 2009 14:26
Please post your explain plan stat. report.

SQL> set autotrace on explain statistics
SQL>

Execute your sql query.

Another one:
Michel Cadot wrote on Wed, 18 February 2009 11:20
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

Then provide the requested and usual information.

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

And so on.

[Updated on: Wed, 29 April 2009 06:18]

Report message to a moderator

Previous Topic: Check valid date
Next Topic: subtract date
Goto Forum:
  


Current Time: Mon Dec 05 12:55:14 CST 2016

Total time taken to generate the page: 0.06999 seconds