Home » RDBMS Server » Performance Tuning » Sql stmt tuning (Oracle 8i)
Sql stmt tuning [message #342035] Thu, 21 August 2008 02:33 Go to next message
chinmayikkalki
Messages: 11
Registered: April 2008
Junior Member

Hi Experts,

ANY SUGGESTIONS ON tuning the following query.

SELECT DISTINCT DATE1
FROM FULCRUM.DFT_GL_ALL_ACCOUNTS_HISTORY AH
WHERE DATE1 >= '01-mar-08'
AND NOT EXISTS  (SELECT ACCOUNT_ID 
  FROM FULCRUM.DFT_GL_ALL_ACCOUNTS_HISTORY  
  WHERE ACCOUNT_ID = '26481'  
  AND DATE1 = AH.DATE1 )
Re: Sql stmt tuning [message #342041 is a reply to message #342035] Thu, 21 August 2008 02:46 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- 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.

Regards
Michel
Previous Topic: Performance Issues After Migration
Next Topic: how to calculate IO for specific SQL Query...
Goto Forum:
  


Current Time: Sun Dec 04 08:45:10 CST 2016

Total time taken to generate the page: 0.07845 seconds