(Bobby Durrett) A coworker of mine cleaned up a bunch of old data to improve performance on an older system of ours and one of the queries started running slower. It looks like the optimizer was choosing a full table scan when an index existed that was much faster.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help