I have a table with 5000 users along with 6 years of attendance data. If I want to retrieve user data from the table it takes time to load.
Usercode, Rosterdate, Shift code, AttendanceCode
If i want to retrieve the shift information from 1-jun-2020 to 10-jun-2020 for 5000 users,
would take time to retrieve the data in SQL server.
what kind of index should i update in above table?