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>
> 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.
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