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

Home -> Community -> Mailing Lists -> Oracle-L -> Index organized tables

Index organized tables

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 24 May 2000 10:13:19 -0400
Message-Id: <10507.106527@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0198_01BFC568.AEFA8EB0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

My question is - how to reuse space in Index Organized Table (IOT) after = deleting substantial amount of rows.
When I deal with regular table, after deleting a lot of rows I rebuild = the indexes in order not to leave gaps in the index blocks, because we = know that this empty space in the indexes will not be reused (unlike, = when it is reused in table blocks after PCTUSED threshold met in the = block).
So, what could be done with IOT in order to prevent constant growth, = even after a lot of rows being deleted?

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com
 =20

------=_NextPart_000_0198_01BFC568.AEFA8EB0 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>My question is - how to reuse space in Index =
Organized Table=20
(IOT) after deleting substantial amount of rows.</FONT></DIV>
<DIV><FONT size=3D2>When I deal with regular table, after&nbsp;deleting =
a lot of=20
rows I rebuild the indexes in order not to leave gaps in the index = blocks,=20
because we know that this empty space in the indexes will not be reused = (unlike,=20
when it is reused in table blocks after PCTUSED threshold met in the=20 block).</FONT></DIV>
<DIV><FONT size=3D2>So, what could be done with IOT in order to prevent =
constant=20
growth, even after a lot of rows being deleted?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>Igor Neyman, OCP DBA<BR>Perceptron,=20
Inc.<BR>(734)414-4627<BR><A=20
href=3D"mailto:ineyman_at_perceptron.com">ineyman_at_perceptron.com</A><BR>&nbs= p;=20
<BR></FONT></DIV></BODY></HTML>
Received on Wed May 24 2000 - 09:13:19 CDT

Original text of this message

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