Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow query on table after adding 6 million rows....

Re: Slow query on table after adding 6 million rows....

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Wed, 11 Oct 2000 19:30:30 -0700
Message-ID: <Bl9F5.34641$XV.1873175@nntp3.onemain.com>

What is the explain plan? Is the index marked unusable? Jim
<sbrendan_at_my-deja.com> wrote in message news:8s2b01$m4i$1_at_nnrp1.deja.com...
> We have a datawarehouse database based on a 'star' schema.
>
> Each month we 'roll' forward the prior months data into a new months
> partition.
>
> When we rolled 'Septembers' data into 'Octobers' partition query time on
> just the 'October' partition slowed down and is now four times slower
> than the 'September' partition for the same amount of data.
>
> There are five keys on the table, are are number(38).
>
> We have been working with Oracle support for five days and do not have
> any relief yet.
>
> We have moved the data accross table spaces, changed index scheme,
> changed degree of parallel, unpartition the table, all produced the same
> slow results.
>
> Could there be a problem when copying data from one partition to
> another?
>
> Looking for any ideas on what might be the problem.
>
> Thanks.
> - Brendan
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 11 2000 - 21:30:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US