How are Indexes Update ?

Indexes are automatically maintained and used by ORACLE. Changes to table data are automatically incorporated into all relevant indexes.

Interview Candidate
Sep 5th, 2004
3
1631

Concepts and Architecture

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

C.Ramesh

Oct 18th, 2007

Index is a Database object . It can be accessed rows physical fast. when you move the table from different table spaces or same table spaces indexes will unusually status. So You compulsory rebuild the index. Rebuilding the index is very fast than drop and create the new indexes.