Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Partition Table and Index

Re: Partition Table and Index

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Thu, 20 Jul 2006 00:34:28 GMT
Message-ID: <ocAvg.127800$H71.121443@newssvr13.news.prodigy.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US