检测sql语句执行效率

SET STATISTICS io ON
SET STATISTICS time ON

SELECT * FROM Car_Model ,(SELECT COUNT(Par_ID) AS total,Mod_ID FROM Car_Part where exists 
(SELECT Mod_ID FROM Car_Model where Car_Model.Mod_ID=car_Part.Mod_ID and Mod_UpdateType <> 'D' ) group by Mod_ID )
 as tbModID  where tbModID.mod_ID=Car_Model.mod_id order by fac_id

SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF