Re: rebuild indexes

From: Rich Jesse <>
Date: Fri, 18 Apr 2014 12:44:20 -0500 (CDT)
Message-ID: <>

Hey Brian,

> A vendor wants me to shrink a table. I've never shrunk one in oracle. Does
> that delete the data out of them?

Nope. Just frees the empty space:

> And then wants me to rebuild the associated indexes. Won't they be empty
> after you shrink them?

I would be wary about this operation. The "why" is very important here. If the table's going to grow after the shrink, then there's a chance that performance could suffer after the shrink/rebuild:

(URL will probably split -- sorry)

Research and benchmarks should help here.

HTH! GL! Rich

Received on Fri Apr 18 2014 - 19:44:20 CEST

Original text of this message