Re: Partitioning with DATE
From: Luciana Missao Osako Camargo <lcamargo_at_cpqd.com.br>
Date: Fri, 27 Mar 2015 13:36:15 -0300
Message-ID: <CA+otyfbZfHVE86HtSQ5pQ-V6v6snOu8xhhUMUG=pZ5YdbW6GLA_at_mail.gmail.com>
>
> Hello,
>
> I have a question on how to get the best of partitioning option.
> I have a table with a large volume of data and the possibility to gain
> more volume because it is a history.
> The most frequent query clause it is by date.
>
> I have the *same date* in three attributes of content :
> complete_date: YYYYMMDD
> month_year: YYYYMM
> year: YYYY
>
> The problem is that I do not know if the query will be for days
> interval ( complete_date atribute) for months interval ( month_year
> atribute) or year (s) (year atribute). It is an analytical query.
>
> Would have some way of defining the partitioning key for any of the
> three query conditions that are able to take advantage of partitioning ?
> For data volume distribution, the partition with month_year atribute is
> good.
>
> My database:
> Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -
> 64bit Production
> With the Partitioning, OLAP, Data Mining and Real
> Application Testing options
>
>
> Thanks!!
>
> Luciana
>
Date: Fri, 27 Mar 2015 13:36:15 -0300
Message-ID: <CA+otyfbZfHVE86HtSQ5pQ-V6v6snOu8xhhUMUG=pZ5YdbW6GLA_at_mail.gmail.com>
>
> Hello,
>
> I have a question on how to get the best of partitioning option.
> I have a table with a large volume of data and the possibility to gain
> more volume because it is a history.
> The most frequent query clause it is by date.
>
> I have the *same date* in three attributes of content :
> complete_date: YYYYMMDD
> month_year: YYYYMM
> year: YYYY
>
> The problem is that I do not know if the query will be for days
> interval ( complete_date atribute) for months interval ( month_year
> atribute) or year (s) (year atribute). It is an analytical query.
>
> Would have some way of defining the partitioning key for any of the
> three query conditions that are able to take advantage of partitioning ?
> For data volume distribution, the partition with month_year atribute is
> good.
>
> My database:
> Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -
> 64bit Production
> With the Partitioning, OLAP, Data Mining and Real
> Application Testing options
>
>
> Thanks!!
>
> Luciana
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 27 2015 - 17:36:15 CET