Q
Problem solve Get help with specific problems with your technologies, process and projects.

Speed of low-cost query

A SearchOracle.com member asks why a low-cost query has a slower speed than expected.

The cost of my query is low (around 300), but it takes 30 seconds for the result. Why?
This is the type of question that can have a million answers. If all we look at is the cost we would assume that Oracle has optimized the cost, but there are many factors that will affect performance. I would ask you, what type of data are you selecting? Are indexes being used? How is the data being selected? Are there filters? What is the state of the data in the database? Are you having network issues? Where is your data located? I can continue, but I am sure you get the point.

What you need to do instead is look at what is happening. It might be time for you to run Statspack or AWR and analyze what is happening to your statement. Are there waits? Is there a large disk read? So I would say that there is no silver bullet on this one. It will be necessary for you to investigate the symptoms and make a diagnosis.

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close