Ok

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.