Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partition Table and Index
"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message
news:44bde4a6.1602437_at_news.hetnet.nl...
> 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.
No it isn't. Received on Wed Jul 19 2006 - 19:34:28 CDT