Re: Managing Large Tables

From: Kyle <kyle_at_gadgets.co.nz>
Date: Wed, 27 Mar 2002 13:23:16 +1200
Message-ID: <O89o8.1765$eF4.214575@news02.tsnz.net>

If you range partition the resulting execution plan is based on your WHERE clause. The optimizer works out which partitions to eliminate therefore no need to offline them. Bind vars can screw this up some.

Regards,
Kyle

"anil chada" <Anil.Chada_at_oracle.com> wrote in message news:70f5d1b6.0203261701.55c003eb_at_posting.google.com...
> Hi --
>
> We have about 10 tables which have lot of records (in millions) and
> these tables are causing performance problems.
> Most of the time users use only current year's information, so i am
> just thinking if we partition the tables and put current year's
> information in one partition and put remaining information in another
> partition
>
> My question is
> Can we somehow take the old year's partitioin off-line, so that oracle
> has to scan through this year's information only?
>
> does this approach help improve performance at all?
>
> I just want to get some ideas from you guys.
>
> Thanks
>
> Anil Chada
>
Received on Tue Mar 26 2002 - 19:23:16 CST