RE: Load and Query question
- From: "Shreeni" <shreeni@xxxxxxxxxxxxx>
- To: "'David Aldridge'" <david@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 27 Apr 2006 13:11:54 -0500
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@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, April 27, 2006 1:05 PM
To: shreeni@xxxxxxxxxxxxx
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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
