RE: Load and Query question

Proportion wise the time taken is less. Most of the time the queries finish in under 40 mins for all the tables. However on some occassions when there has been a significantly larger load, the queries just drop dead. We then either drop/recreate the indexes or force a hint into the query.  

Thanks
Shreeni

-----Original Message-----
From: David Aldridge [mailto:david_at_david-aldridge.com] Sent: Thursday, April 27, 2006 1:05 PM
To: shreeni_at_sbcglobal.net
Cc: 'Oracle Discussion List'
Subject: Re: Load and Query question

"minus" still ought to work and perform OK if the query can read indexes, even if functions are applied to the values ... have you validated that indexes are being used instead of FTS? Do you know what proportion of your total load time is taken up with the minus ops?

Shreeni wrote:
> Sure....We have two instance of each table. One is trunc-reload daily and
> the other a pseudo history table which is insert only. There is a huge
push
> to implement async-CDC shortly so that we load only deltas. Our team is
not
> in the loop as it is not seen as DBA related !!
>
> Promise me you wont laugh at this. All the descriptive columns are NOT
NULL.
> So they default to a single space. These minus queries are written with
trim
> and NVL functions...so though we have proper indexes in place most of the
> time the queries perform badly....The list goes on...
>
> Thanks
> Shreeni
>
>

--
http://www.freelists.org/webpage/oracle-l