Re: Index strategy for huge partitioned table

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Wed, 23 Aug 2006 01:36:46 GMT
Message-ID: <OiOGg.2082$yO7.1170@newssvr14.news.prodigy.com>

<vinsharma1808_at_gmail.com> wrote in message news:1156286518.909297.126880_at_h48g2000cwc.googlegroups.com...
> is your situation like as below.
>
> table A partitioned on the basis of a date field say D1, and there is
> no index for D1?
>
> If so, do your application using SQL queries on this table with WHERE
> condition on field D1 frequently? How many partitions you defined on
> that table on field D1.?
>
>
>

This table is basically exactly like you stated. There's even more large partitioned tables that do the same thing. They're not currently directly under my realm of responsibility so other than trying to point things out and make little victories there's not much I can do right now. I'm hoping I can improve the one table they asked me to look into and it will go from there. Received on Tue Aug 22 2006 - 20:36:46 CDT