• Use this to create indexes for you tables in database which helps to retreive data faster.
• Indexes act like book marks which we keep in a book to access any page instantly.
  

Command Syntax:

CREATE INDEX Name of index ON table name (column1,column2,....)

Sample that I used:

CREATE INDEX GPSLOCATION_INDX1 ON GPSLOCATIONS
(LASTUPDATE, PHONENUMBER)