Re: Archiving Records

A lot of 'it depends' related to this question.

For example, it depends on the version of Oracle and it depends on whether you have (legal) partitioning installed. If you have partitioning installed and configured to handle the archived information on an 'archive' set of tablespaces, the problem could virtually disappear, because the where clause could tell the optimizer to ignore
'archived' data.

/Hans

"Daniel A. Morgan" wrote:

> Omar Malik wrote:
>
> > hello all
> > I was wondering if someone can give me some techniques for being able to
> > query database faster and enhance its performance. Is there a way of
> > archiving records where during a query some records are not looked at, since
> > they have no relevance to our search. Maybe if we can put some of the
> > records to sleep before searching the database. Point is to be able to
> > search faster.
> > Any help will be appreciated.
>
> Create a field on your table indicating active or archive. Then create a bitmap
> index on the field.
>
> Use that field in your WHERE clauses.
>
> Or ... move them to different tables in another tablespace.
>
> Daniel A. Morgan
Received on Fri Jun 22 2001 - 13:08:51 CDT