-
Indexing on frequently updated table
I was asked a question in an interview, where I was given a situation which is: I have registered to an online gaming website. It displays my rank on the basis of my score when I play a game. Database table has 2 columns: 1. UserName 2. Score. Since the login page was loading very slowly so the programmers created an non-clustered index on UserName and now the welcome page problem is solved. But since...