Even with indexes, your DB can slow down due to Fragmentation. This happens after many Inserts/Deletes.
The Pro Check: Run this to rebuild all indexes on a table and reclaim performance:
ALTER INDEX ALL ON MyTableName REBUILD;
Related posts:

SQL Server: Fix a Partitioned Table's Partition Switch Silently Failing Because the Staging Table's ...

SQL Server: Fix ON DELETE CASCADE Silently Deleting Rows Several Tables Away Through a Chain of Fore...
