Re: Using global index on partitioned table vs index on the same but non-partitioned table
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 18 Apr 2016 11:24:01 -0400
Message-ID: <5714FC11.7020800_at_gmail.com>
On 04/18/2016 09:30 AM, Tim Gorman wrote:
> Global indexes use extended rowids (10 bytes) in the index leaf
> blocks, while indexes on non-partitioned tables and local indexes use
> the restricted rowid (6 bytes).
>
>
>
Date: Mon, 18 Apr 2016 11:24:01 -0400
Message-ID: <5714FC11.7020800_at_gmail.com>
On 04/18/2016 09:30 AM, Tim Gorman wrote:
> Global indexes use extended rowids (10 bytes) in the index leaf
> blocks, while indexes on non-partitioned tables and local indexes use
> the restricted rowid (6 bytes).
>
>
>
And that results in the faster filling up of the leaf blocks, more block splits and higher level of the index. However, it is possible to use local, prefixed indexes even as a primary key. A global index on a partitioned table is a reason for re-evaluating the data modelx. Regards
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 18 2016 - 17:24:01 CEST