Re: Index nearing maxextents

From: Dan Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 11 Nov 1998 13:16:38 -0800
Message-ID: <3649FEB6.89DA3CEF@exesolutions.com>

> I have an index that is nearing its maxextents. I'm not sure which is the
> best way to handle this:
>
> 1. export and re-import the table
> 2. drop and re-create the index

Drop and recreate the index. And by all means keep the index when you recreate it to one extent by creating an appropriate storage clause. Even though Oracle has now made it possible to have effectively unlimited extents this option is for the lazy that don't care about performance. A good rule of thumb is to never let the number of extents exceed 20.

Daniel A. Morgan Received on Wed Nov 11 1998 - 15:16:38 CST