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

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 11 Nov 2008 16:59:59 +0100
Message-ID: <4919abff$0$183$e4fe514c@news.xs4all.nl>


bdbafh schreef:
> On Nov 10, 3:52 pm, zigzag..._at_yahoo.com wrote:
>> I am using Oracle 9.2.0.5 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