Home » RDBMS Server » Performance Tuning » Tuning
Tuning [message #228260] Mon, 02 April 2007 05:26 Go to next message
dr46014
Messages: 48
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
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: 611
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
Re: Tuning [message #228398 is a reply to message #228323] Mon, 02 April 2007 22:40 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You may also need to gather stats on that index.

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


Current Time: Sat Dec 10 00:56:30 CST 2016

Total time taken to generate the page: 0.09672 seconds