Re: Tuning Question

Hello RC,

  Yes - date field is a very good candidate for the range partitioning.

   If you decide to go with the partitioning make sure to do QA tests firs and verify, that SQL execution plans are improved.

Regards,

Support

DBA Infopower

https://www.dbainfopower.com

The advice provided by DBA Infopower are provided "as is" with no warranty. DBA Infopower expressly disclaims any warranty, regarding the advice including any implied warranty of merchant fitness for a particular purpose aviating course of dealing and/or performance. DBA Infopower does not warrant that the advices provided by DBA Infopower will be free from bias, detests, errors, eavesdropping or listening. DBA Infopower shall not be responsible for the quality of information or the authentication of the services or details given by experts on the advice. By using this advice the user of the advice accepts the terms and conditions of this statement.

<spam_at_no-spam.com> wrote in message
news:40235472.252825243_at_news.demon.co.uk...
> On Thu, 5 Feb 2004 23:22:27 -0800, "DBA Infopower Support"
> <support_at_dbainfopower.com> wrote:
>
> >Hello RC,
> >
> > Please, check "where" clause of the most frequently executed SQL and
make
> >sure you have indexes that satisfy your "where" clause. Use SQL "explain
> >plan" to verify.
> >
> > Use of the partitions would help optimizer to choose only needed
> >partitions, but only in case if "where" clause of the SQL includes full
or
> >partial partition keys.
> >
> > Generally it is best to partition both table and corresponding
indexes
> >(as local).
> >
> > If you can not allocate maintenance window to partition table and
> >indexes then partition index only can be created online with no downtime.
> >
> > Please, let us know if you have any additional questions on this
topic.
> >
> >Regards,
> >
> > Support
> > DBA Infopower
> > http://www.dbainfopower.com
> >
> >
> The table I want to partation has field called period (account period
> in yyddmm format) most of my queries will have that in the where
> clause.
>
> Can you commnet on this DBA Infopower
Received on Fri Feb 06 2004 - 12:29:53 CST