Advance SQL Concepts

Posts under this category will deal with beginner to advanced SQL Concepts. Most of the articles here will have a easier version explained in SQL Beginner articles.
This is to make sure we cover topics according to the levels of understanding.

How SQL Index Works | SQL Index Part 2

How does SQL Index Work is a question that requires an answer which is creative , imaginative & precise in it’s nature. SQL Index is one of the most important and famous tool in the world of SQL developers. Developing it’s working mechanism and behaviour will help you in deciding whether it’s going to complete your requirements or not.