Managing Large Tables

From: anil chada <Anil.Chada_at_oracle.com>
Date: 26 Mar 2002 17:01:25 -0800
Message-ID: <70f5d1b6.0203261701.55c003eb@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:01:25 CST