Re: serious performance downgrade on partitioned table.

From: Kendall <kendallwillets_at_yahoooo.com>
Date: Thu, 17 Jan 2002 17:38:04 -0800
Message-ID: <u4ev3sjek3q2de@news.supernews.com>

In article <8375780b.0201171655.77fe94e2_at_posting.google.com>, "Jessica Mao" <hym0_at_hotmail.com> wrote:

> Table event_t has 14 range partitions, only 1 out of 14 contains data --
> about 1 million rows. A workload called CSR has a query on event_t. When
> event_t increased from 1 million rows to more than 2 million -- still
> inside 1 partition, CSR throughput dropped from 390 ops/sec to 200
> ops/sec. Here's the query statement:
>

It's possible that the size of the index range scan has simply doubled. Are you scanning more rows matching the predicates on end_t and account_obj_id0? Received on Thu Jan 17 2002 - 19:38:04 CST