Hi all today we are going to discuss about Indexing.
What is indexing? Have you thought what would happen
if it was not there?
Basically indexing is a SQL concept that is used to
retrieve the data from the database in fast and efficient way. If it was not
existed then fetching data from Databases would have taken hours/days/Months
and we would be standing hungry in queues of the food chains of McDonald'/KFC for long hours.
Let's see how it works:
Have you imagined how you can search chapters if you
don't have the index in your book?
Book is the perfect example of indexes, suppose if any
of your teacher asked you to show any random chapter content. How will you show
her/him?
You will navigate to index page of your book and will
find out the page number. In this way you would be able to track the chapter in
a quickest way. On the other side if you were not having the index page in your
book, you will have to jump from one page to another till you would have found
it.
As you can see indexes in the book helped us reduce
the time significantly, in the similar fashion indexes helps tables/views to
find the data quickly.
