Concepts and Architecture Interview Question:

Do you know how are Indexes Update?

Submitted by: Administrator

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.
Submitted by: Administrator