Topic : Index

Explain what partitioning is and what its benefit is.


Answer :

Partitioning is a method of taking large tables and indexes and splitting them into smaller; more manageable pieces.

Show Answer Discuss

What is an Oracle index?


Answer :

An index is an optional structure associated with a table to have direct access to rows; which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

Show Answer Discuss

What are the types of partitions?


Answer :

There are five different types of partitions as follows are
Range : Divides up rows based on ranges of values.
Values List : Divides up rows based on sets of literal values.
Hash : Uses a hashing algorithm to divide rows; resulting in the most consistently sized partitions.
Composite Partitions : Contains subpartitions within each separate partition : Range?Hash : A range partition containing hash subpartitions within each range partition.
Range?List : A range partition containing list value subpartitions within each range partition.

Show Answer Discuss

What are the types of Partition Indexing?


Answer :

Partitions can have indexes. There are two types of partition index are :
Local Index
Global Index

Show Answer Discuss