In this article, we will discuss about several topics on index in oracle database. The topics are as follows:
What is Index and what are their types?
How to create Index?
How to alter index?
How to rebuild index?
How to handle index corruption?
What is index: An index in oracle database is a schema that contains an entry for each value that appears in the indexed columns of the table. It offers facility to fast access of the rows.
What is Index and what are their types?
How to create Index?
How to alter index?
How to rebuild index?
How to handle index corruption?
What is index: An index in oracle database is a schema that contains an entry for each value that appears in the indexed columns of the table. It offers facility to fast access of the rows.
