Re: Are there performancebenefits to reorganizing database-using export/import?

From: Shakespeare <>
Date: Tue, 11 Nov 2008 16:59:59 +0100
Message-ID: <4919abff$0$183$>

bdbafh schreef:
> On Nov 10, 3:52 pm, wrote:
>> I am using Oracle on HP UNIX 11i. Since it is a production

> While you are at it, you might consider key compression of
> concatenated indexes.
> This can reduce the space used by indexes, but you might need to re-
> order the columns in the index in order to gain the space reduction
> that you're after.

I would definitely NOT advise to do so. Column order is rather important in indexes!

Shakespeare Received on Tue Nov 11 2008 - 09:59:59 CST

Original text of this message