In previous article we have seen overview of index partitioning and advantages of it. In this article we will see example of different types of indexes on partitioned tables. 1.Non-partitioned Index: We can create normal non-partitioned index on partitioned table. Example : TRANSACTIONS table is partitioned table in my database. 2.Global Range Partitioned Indexes : […]
Articles Tagged: index partitioning
Index Partitioning
In previous article we saw what is partitioning in oracle and the benefits it brings . http://oracle-help.com/oracle-database/oracle-partitioning/ In this article we will see Index partitioning. Indexes are the essential part of any SELECT and DML operations which we run on the database. So , when we tune the table we must consider […]