Indexing is a data structure technique to efficiently retrieve records from the database files based on some attributes on which the indexing has been done. Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. This work focuses on various indexing methods used in RDBM files to enhance and optimize the query processing.