OVERVIEW :

• An index is a database’ essential  structure and a component which makes faster , quicker and easier to find data based on more than one columns.

• We can think of an index in database just like of searching a word in a dictionary .

• For example : If you want to search a word : “Computer” , you have two paths to go to that word : First , go page by page in sequential word by word order , second path is : You quickly start searching through the Alphabet , like first in C then  : ->o->m->p->u->t->e->r .

• The first path will take for example : 1 minute to reach the word , the second path will take 10 seconds to reach the word . This is the beauty of Indexing , it reduces the path to the best optimal path and saves time.

 

• 8. Indexing