Re: When should one rebuild an index?

From: joel garry <joel-garry_at_home.com>
Date: Tue, 13 Jan 2009 11:00:23 -0800 (PST)
Message-ID: <a338b7e1-b42c-469d-b65f-dd1fa5cfeadf_at_z27g2000prd.googlegroups.com>

On Jan 13, 6:17 am, raja <dextersu..._at_gmail.com> wrote:
> Hi,
>
> I have a doubt regarding rebuilding indexes on max partition.
>
> Please explain me / tel me how can we proceed regarding the following
> scenarios :
> ---------------------------------------------------------------------------­---------------------------------------------
> 1. rebuilding indexes on a max partition with data
> 2. rebuilding indexes on a max partition with data on local indexes
> 3. rebuilding indexes on a max partition with data on global indexes
> 4. rebuilding indexes on a max partition without data
> 5. rebuilding indexes on a max partition without data on local indexes
> 6. rebuilding indexes on a max partition without data on global
> indexes
>
> Table partition details are as follows :
> -----------------------------------------------------------------------
> partitioning_type    subpartitioning_type
> list                           none
> range                        hash
>
> Index partition details are as follows :
> -----------------------------------------------------------------------
> partitioning_type    subpartitioning_type
> range                        hash
>
> If someone explain with examples or provide URLs having examples, i
> would be very much thankful.
> Please help on this by detailed explanation.
>
> With Regards,
> Raja.

http://www.google.com/search?hl=en&q=index+unusable+geist+site%3Aforums.oracle.com&btnG=Search

jg

--
_at_home.com is bogus.
Amazon New Yorkers on the Moon.
http://www3.signonsandiego.com/stories/2009/jan/13/1b13webtax01460-states-seek-sales-tax-online-purch/?uniontrib

Received on Tue Jan 13 2009 - 13:00:23 CST