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

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 04 Sep 2004 00:47:40 GMT
Message-ID: <Mg8_c.15474$Zc2.13289@newssvr27.news.prodigy.com>

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 Received on Fri Sep 03 2004 - 19:47:40 CDT