DML command and Index

Data manipulation commands are used to manage data. Using DML command, you can create new records, update records and delete records. The following commands fall in this category.

SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE - deletes all records from a table.

 

What is an Index?

Index in oracle helps to trace the information faster just like an index in a book. Index entries keep information about the columns that are part of the index in a sorted order. If you query data with an index, the data retrieval is much faster.