Q

Reducing time to process a query

We are using Oracle Business Intelligence 10g. When we click on a worksheet it takes so much time to process the query. Is there any possibility that we can reduce this elapsed time of querying?

We are using Oracle Business Intelligence 10g. We have a problem: when we click on a worksheet it takes so much time to process the query. Is there any possibility that we can reduce this elapsed time of querying? Please help me out in this aspect.
Slow performing queries or tools that perform queries that run slowly are the symptom that it appears you are seeing. Therefore you must approach this as a performance tuning issue.

You will need to evaluate the SQL that is being executed. This SQL may require tuning or may lead you to physical

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.

This was first published in September 2005

Dig deeper on Oracle and SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close