Scalability and performance are the common buzzwords whenever we are dealing with large data sets, and to help further, indexes and statistics play an important role in query performance. A Database Administrator or Developer needs a good understanding of the indexing methods, which can result in efficient practices to return the required subset of data based upon the index key columns and their values.

Inside the database, the data is inserted, deleted, and updated frequently; to return subsequent results efficiently, indexes are helpful. However, NULL values are present in the data, and if it is likely that null values are stored in the data on a larger scale, the indexes will need efficient design for better performance.