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

Tuning an expensive SQL statement

I am using Oracle 9i Database on Windows 2000 Server. When I ran the query for expensive SQL statements in my production database I found the following statement. How do I tune this query?

I am using Oracle 9i Database on Windows 2000 Server. When I ran the query for expensive SQL statements in my production database I found the below statement. How do I tune this query?
UPDATE EQUIPMENT_USES SET EXPORT_RELEASE_NBR=:b1,CHANGED=DB_DATE
> ,CHANGER=USER WHERE GKEY IN (SELECT EQUSE_GKEY FROM BL_EQUIPME
> NT WHERE BL_GKEY = :b2 AND CATEGORY IN ( 'I','T','S','R' )) 
Are you sure that the query needs tuning? Just because it's identified as "expensive" does not mean that there is a problem. Are users satisfied with the amount of time it takes them to perform operations using your database applications? If the answer to that question is "no," then you should trace the operations that perform unacceptably, determine from the formatted trace file which database operations consume the most time, and then determine the reason that they consume so much time.

Dig Deeper on Oracle and SQL

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