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
Messages: 51
Registered: January 2009
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'

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
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: 65137
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?
Did you read & follow Posting Guidelines as contained in URL below?

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

SQL> set autotrace on explain statistics

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.


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: Thu Aug 17 06:49:29 CDT 2017

Total time taken to generate the page: 0.10996 seconds