INDEX

Index Scanning Methods In Oracle:

Its is a method to retrieve a row by traversing through the index, using index column value specified by the statement.

The index scan first locate the root block of the index. Then it …

How Index affect table access in Oracle?

Index in brief:

• Index is a schema object.
• Its created based on a table or cluster column.
• It contains an entry for each value that appears in the indexed column of the table

ALTER INDEX Remove or Add column in Oracle

ALTER INDEX features for developers:

Developers can use ALTER INDEX command for the following operations:

• RENAME Index Name
• Disabling Index
• Enabling Index
• Creating UNUASABLE Index
• Making Index INVISIBLE
• Making Index VISIBLE

RENAME