Re: Oracle Partitioning
Date: Mon, 28 Oct 2013 10:21:29 -0500
Message-ID: <CAP79kiSrZNJeyRAat=FQn7Bwtba+x=5uCqoDaG9JVSEGcNje-Q_at_mail.gmail.com>
I don't know how much you know about Oracle partitioning (and I don't know much - but more than I did a year ago) is you can have 2 basic types of indexes on partitioned tables:
Global partitioned index and local partitioned indexes. So yes there can be some benefits when using index access methods even if you touch every partition. And vise versa, there be can severe penalties if your partitioning scheme doesn't match the application usage. You want to match partitioning methods to the way the application access the data.
I don't know if that helps much but thought I'd throw it out there.
Chris
On Mon, Oct 28, 2013 at 8:58 AM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:
> We are looking into the possibility of licensing the Partitioning option.
> My understanding of partitioning is that it only helps when the optimizer
> can eliminate partitions. Doesn't that mean that it is primarily of
> benefit when accessing the tables via full table scans? In that case, the
> optimizer could eliminate partitions from scanning. If, however, you are
> accessing the data via an index\, would there be any benefit?
>
> Is my understanding of this correct?
>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> Information Systems
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>
>
>
>
> .
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 28 2013 - 16:21:29 CET