Re: Load and Query question

my sympathies.


On 4/27/06, Shreeni <shreeni@xxxxxxxxxxxxx> 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 though we have proper indexes in place most of the
> time the queries perform badly....The list goes on...

Other related posts: