You will need to evaluate the SQL that is being executed. This SQL may require tuning or may lead you to physical...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
changes that you need to make. You may need to add indexes or even change your indexing strategy. You may want to implement partitioning or materialized views. One idea is to use the Materialized View Advisor if your query is an aggregation.
The tool may also have options that help to provide you with the performance you are looking for. Again, understanding what is being run and how it is being run may lead you to the performance bottleneck.
Dig Deeper on Oracle and SQL
Related Q&A from Ian Abramson
A SearchOracle.com member asks why a low-cost query has a slower speed than expected.continue reading
A SearchOracle.com member asks, "I just rebuilt an index with 35 million rows in it. Do I have to analyze the index after rebuild?"continue reading
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.