Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning Question
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 - 02:48:33 CST