The index is a schema object and index are optional structure associated with tables. The index is a pointer to a location of data. The index use for your searching and this option search is fastly. The index always create with the where clause condition. The index is necessary on any column or combination of columns that must be unique.  More...