Re: Possible? Index on partitioned table with index only being associated with one of the partitions...

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 04 Sep 2004 07:33:58 -0700
Message-ID: <1094308497.953043@yasure>

Mark Bole wrote:

> Andy wrote:
>

>> Hi Greg,
>>
>> As far as I know it's not possible to create an index on the
>> individual partitions of a table. [...]
>> Andy
>>
>> gforestieri9_at_yahoo.com (Greg Forestieri) wrote in message 
>> news:<6a8cdd95.0408250820.5fa272f3_at_posting.google.com>...
>>
>>> Possible?  Index on partitioned table with index only being associated
>>> with one of the partitions...

>
> [...]
>

>>> Background - we have a "datawarehouse" (I use the term loosely here)
>>> that has several multi-million row tables.  The tables have been
>>> partitioned on year, so that the partitions look like this:
>>>

> [...]
>

>>>
>>> For the purpose of saving index space is it possible to build an index
>>> that only indexes the YR2004 partition?  [...]

>
> [...]
>
> There are two schools of thought here (not necessarily incompatible):
>
> "disk is cheap, why bother saving index space?"
>
> "every time the manager says, 'disk is cheap', still somehow it never
> magically appears when and where needed".
>
> The goal that has been set is not really a reasonable one, in the
> context of a commercial enterprise -- if there is value in the data,
> surely there is even more value in the small incremental cost of
> indexing [all of] it.
>
> --Mark Bole

For every genius that says "Oh we never query that" ... there are at least three end-users doing exactly that.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sat Sep 04 2004 - 09:33:58 CDT