How Index's are Working

How Index’s are working?

Before Creating how  index is working:

Journal	Volume	Issue	Article
JOP	101	2	2436
HPJ	153	0	7841
ASEM	0	0	3251
JOP	101	2	5621

             

  

Now we search the Journal “JOP” and article “5621”. It’s Read entire table and provide data.

After Creating Index for Table Structure:

Index Created for Journal Column:

Journal

JOP

HPJ

ASEM

The above index refer the relevant journal in the below table.

Journal	Volume	Issue	Article
JOP	101	2	2436
HPJ	153	0	7841
ASEM	0	0	3251
JOP	101	2	5621

After creating index for the “journal” column now it’s not read entire data, based on the index column its retrieve data more quickly. We can able to identify the difference at the time large table only.