what is actually an index and how does it processes quickly?? | Sololearn: Learn to code for FREE!

+1

what is actually an index and how does it processes quickly??

index

sql

7/14/2016 8:16:34 PM

manish rawat

1 Answer

New Answer

0

They work pretty much like a index in a book. By looking at a book's index you can jump easily to where a chapter begins. Similarly, if you create an index on a table field, the SELECT statement with a WHERE on that field will return quickly the expected result. If there wasn't an index, the query would scan all of the table records one by one, thus giving a poor performance.