Home » RDBMS Server » Performance Tuning » Tuning
Tuning [message #228260] Mon, 02 April 2007 05:26 Go to next message
dr46014
Messages: 49
Registered: February 2007
Member
please help me to optimise the query......
select EQUIFAX_CUST_ID,CURRENT_ACCOUNT_NBR FROM CMAP_OWNER.CUST_EQX_ACCT_DIM where
effective_end_date is NULL and LOAD_DATE in (select max(LOAD_DATE) from cmap_owner.CUST_EQX_ACCT_DIM)

there is no partition and index...
no index or partition is to be created as it ll affect many queries in the entire process.there is around 150 million records..
its taking a lot of time to select...
reply ASAP

Report message to a moderator

Re: Tuning [message #228323 is a reply to message #228260] Mon, 02 April 2007 09:47 Go to previous messageGo to next message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
If you are not ready to create an index on LOAD_DATE then you'll suffer from BAAAAD performance.

Michael

Report message to a moderator

Re: Tuning [message #228398 is a reply to message #228323] Mon, 02 April 2007 22:40 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You may also need to gather stats on that index.
Ross Leishman

Report message to a moderator

Previous Topic: Does Altering Index Monitoring have Locks
Next Topic: views in 92
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 01:38:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.