Re: Treating idle and active data separately

qazmlp1209_at_rediffmail.com wrote:
> We have a requirement where we need to store 5 mio. of records in the
> Oracle database. Out of these 5 mio., only 3 mio. records will be read,
> modified and used for the processing by the applications. The remaining
> 2 mio. will be stored, but the data from those records will be
> unused(which we will use only in the future).
> As we store all the 5 mio. records, (eventhough only 3 mio. records
> will be processed by the applications) the response time from the
> database is slow. Can we perform any tuning in the Oracle database,
> such that the Oracle also adjusts internally and considers only the 3
> mio. records during the normal access?

How about partitioning the table on the active records criteria? Received on Tue Aug 08 2006 - 02:38:32 CDT