Indexing in Oracle 12C is generally creating an index on a partitioned table, one or more set of columns.
The prerequisites for creating an index are:-
» One should have a Create index privilege
» The indexing needs to be done one the schema owned.
» The privilege of the creating index on object should be there.
The below figure 8.8 shows how an index is created on a portioned table students with primary key id.
- Fig 8.8