Observation: DISTINCT Precedes Atomic Value


You coded a DISTINCT clause before a select list that returns a single, atomic value and a single row. This statement will not return more than one row, so the DISTINCT clause is superfluous. However, it might invoke a sort. Therefore, consider removing the DISTINCT clause from the statement.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*