Oracle Magazine, September/October 2017
DBA PERFORMANCE ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 98 select index_ name partitioned from user_ indexes where table_ name ACCOUNTS INDEX_ NAME PARTIONED IN_ ACC_ BALANCE YES IN_ ACC_ TYPE YES PK_ ACC NO IN_ LAST_ TRANS_ DT NO All the four indexes are present in the newly partitioned table Oracle Database maintained them automatically which is a result of the UPDATE INDEXES clause Because you explicitly specified the IN_ ACC_ TYPE index to be local the index was partitioned as well to match the table For the IN_ ACC_ BALANCE index you explicitly asked it to be global partitioned so it became exactly that You asked the PK_ ACC index to be global but not partitioned so it is not partitioned Finally for the IN_ LAST_ TRANS_ DT index you didnt specify anything so the index was not partitioned Thats the default behavior for an index of an unpartitioned table where the index didnt contain the column on which the table was partitioned In this case the partition column was STATE_ CODE which was not part of the IN_ LAST_ TRANS_ DT index so it was not partitioned When an index contains a partition key column that index is converted to a local partitioned index Bitmap indexes are converted to local partitioned indexes regardless of whether they have the partition key column in their definition Dont worry if you got dizzy while reading all that I will summarize it neatly at the end of this section
You must have JavaScript enabled to view digital editions.