Oracle Index

Index in oracle helps to trace the information faster just like an index in a book...
Table, Views, Index, Synonym and Sequence are the objects of oracle.....
BINARY_INTEGER is a PL/SQL data type defined as a subtype of INTEGER in the STANDARD package and is used for storing signed integers......
An index is a pointer to a location of data. The purpose of an index is to make SQL queries run faster.....
On rebuilding an Index, the existing index is dropped and a new one is built. This operation can consume a lot of time and resources......
Non-key columns can be dropped from a table only after the non-key index is dropped first...
What is composite index? - A composite index contains more than one key column.....