try here for a start https://www.mssqltips.com/sqlservert...s-are-indexed/