Re: Partitioned Table Indexes

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sat, 05 Aug 2006 03:06:22 GMT
Message-ID: <OWTAg.4355$gY6.1464@newssvr11.news.prodigy.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1154744566.872282_at_bubbleator.drizzle.com...
> Dereck L. Dietz wrote:
> > Where I work they have a number of partitioned tables but they have not
> > partitioned any of the indexes on these tables.
> >
> > Pardon my naivity but would/could someone explain whether, in general,
this
> > is a good idea or not?
> >
> > Thanks.
>
> Generally it is a rotten idea. More specifically ... little things like
> version number, explain plan, usage, etc. are important if you want a
> better response.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

All I was looking for, as I said above was a general answer anyways. Thanks. Received on Fri Aug 04 2006 - 22:06:22 CDT