Re: Partition Table and Index

On Mon, 17 Jul 2006 22:55:30 GMT, "Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote:

>We have a partitioned table of approximately 69 million rows. It is loaded
>during a weekly load process and takes about 8 hours to run. According to
>the person who routinely runs the process the majority of the 8 hours is the
>re-indexing process. She is wondering if they entire table needs to be
>re-indexed every week.
>
>I'm not completely sure what type of indexes are on this table other than
>they are partitioned.
>
>Should we check to determine if the indexes are global partitioned or local
>partitioned?
>
>Is there any other advice anybody can offer or ideas where to start to look?
>
>I know the information provided is sketchy and I apologize.
>
>

Is the table completely reloaded (from empty to fully loaded)?

Jaap. Received on Wed Jul 19 2006 - 02:52:54 CDT