Note that nothing I nor anyone else said means that you don't ALSO have suboptimal indexing on your system. In fact I can say that I have NEVER, in 20 years of consulting on SQL Server, met a client that had anything CLOSE to optimal indexing. But getting to that point on anything even moderately complex is a project unto itself and absolutely cannot be done via a forum. 😎