Create index

CREATE INDEX
--------------------------------
Que What do you mean by index ????
Ans :

1.   In a  General we all that  index is  that  in which we have list of important topics having page no on which it is written or  found. so  through the  index the work of searching particular topic is reduced and we got the fast and  optimum result .
2. Same in the database we  create an Index on particular field so that we can easy to find the data and got the result as fast as possible.if we create index that will also  help to retrieve the result that will matter in performance tuning.

For DESCRIBE the  USER_INDEXES TABLE  we have Command  DESC user_indexes
f

DESC USER_INDEXES  command  will  display above  information of  user_indexes table

which has different columns and their data type of that table.

1. Above image  list  the list of  index for the  particular table .  index start from SYS are the  implicit  index which are create when  we create primary key  column.
2. implicit index is create when primary key constraint is add and removed when Primary key constraint is removed.