Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Index organized tables
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 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> </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
![]() |
![]() |