SQL Tuning

How to Correct Wrong Execution Path

Posted on
SQL statements including queries and DML sometimes execute with the different index because of the following reasons: Missing index The target index might be dropped accidentally by someone else. Therefore, the optimizer have no choice but to use the wrong index instead, which may not match your expectations. You should check the existence of desired […]