But when you rebuild, it will reestablish the pctfree in all of the index
blocks. If you had a lot of activity this free space would have been used
in the original index and is now reclaimed.
Jeffrey Beckstrom
Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> [EMAIL PROTECTED] 5/31/02 1:11:54 PM >>> storage parameter difference? None are you moving from one tablespace to pctfree/pctused influence? none I should have put this in the original message. Indexes stayed in original tablespace with identical
-----Original Message----- storage parameter difference? are you moving from one
tablespace to pctfree/pctused influence? --- "Adams, Matthew (GEA, MABG, 088130)"
<[EMAIL PROTECTED]> __________________________________________________
Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051 |
- RE: Rebuilding indexes Rachel Carmichael
- RE: Rebuilding indexes Hatzistavrou Giannis
- RE: Rebuilding indexes Jeremiah Wilton
- Re: Rebuilding indexes Terry Ball
- RE: Rebuilding indexes Rachel Carmichael
- RE: Rebuilding indexes Vadim Gorbounov
- rebuilding indexes Adams, Matthew (GEA, MABG, 088130)
- Re: rebuilding indexes Rachel Carmichael
- RE: rebuilding indexes Adams, Matthew (GEA, MABG, 088130)
- Re: rebuilding indexes Jack Silvey
- Re: rebuilding indexes Jeffrey Beckstrom
- Re: rebuilding indexes Rachel Carmichael
- RE: rebuilding indexes Rachel Carmichael
- Re: rebuilding indexes Jack Silvey
- Re: rebuilding indexes Rachel Carmichael
- RE: rebuilding indexes Ron Rogers
- RE: rebuilding indexes John Kanagaraj