Re: Archiving Records

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 Wed Jun 13 2001 - 19:56:07 CDT