If you have a huge amount of data in the table, and if a particular column is taking too much time to retrieve/fetch. We can apply indexing on that column for faster retrieval
types of indexing
1) clustered index: faster retrieval of data
2) non clustered index: relatively slower to clustered indexing.