SELECT
W. PPID,
U.U SERNAME USERNAMES
The FROM
Umuser U
The JOIN wfworkitemn W ON William ouchi WNERID=U.U SERID
Where
U.P ARENTIDS LIKE '% OR1200000702 %'
GROUP BY
U.U SERNAME,
W. PPID
The ORDER BY NULL

This SQL W table appear Using temporary, U.U SERNAME and w. PPID have been adding indexes and how to ask bosses optimization solution,