Re: Index strategy for huge partitioned table

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 22 Aug 2006 22:07:28 GMT
Message-ID: <AeLGg.2029$yO7.1912@newssvr14.news.prodigy.com>

<vinsharma1808_at_gmail.com> wrote in message news:1156284107.854682.224310_at_75g2000cwc.googlegroups.com...
> Hi, The indexes in the partiitoned tables should be based upon the
> facts 1. Usability 2. maintenance. It all depends upon the column which
> is part of the index. For any column which is being indexed and is also
> the partitioning key, should be indexed as local for better perforance.
> If that column is not partitioned column better to make index global in
> that case.

What about the situation here where the table is partitioned by a date field yet that field is not only NOT part of the partition key but isn't even indexed at all? Received on Tue Aug 22 2006 - 17:07:28 CDT