Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index rebuild

Re: Index rebuild

From: Naren Chintala <naren_at_att.com>
Date: 1998/02/18
Message-ID: <34EB47EF.1098@att.com>#1/1

If you are using the "ALTER INDEX ... REBUILD" command

  1. No DML operations are permitted during the recreation of the index. The Insert/Update/Delete transactions will "HANG". In your terms, the "it just queue until the rebuild is done".
  2. Your queries (SELECT only) will use the index. How? When an "ALTER INDEX REBUILD" command is issued Oracle creates a new index and drops the old one after the new index is created.

Check the user_extents and dba_dml_locks when you rebuild the index.

HTH. Naren

Rick Klainer wrote:
>
> I'm on oracle 7.3.3 on a AIX 4.2.1 Unix server. I find myself having to do
> index rebuilds to keep performance at an exceptable level. My question is;
> If I'm doing a rebuild and I have online activity going on
> will the online activity fail with an oracle message or will it just quene
> until the rebuild is done. (here I'm assuming the online activity is trying
> to update the index) My understandings is that you can still read while the
> index rebuild is going on. Please email with your response. thanks. EMAIL
> rklainer_at_neo.lrun.com
Received on Wed Feb 18 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US