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 )

Report message to a moderator

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: 68665
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 21:00:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.