How are Indexes Update ?

Answer Posted / orawhiz

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

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to export data to a csv file?

610


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1447


What is concurrency in oracle?

530


Why do you use stored procedures and state some of its disadvantages?

554


What the is the diff between local index and global index. give some example.

1124






What is coalesce function?

563


What happens if variable names collide with table/column names?

574


What is oracle data type?

544


How to rename an index in oracle?

610


What is an oracle data file?

600


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2383


How will you write a query to get a 5th rank student from a table student_report?

1350


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1693


how to clone 9i Database on to 10g Database.

1816


How to create a temporary table in oracle?

681