Quest SQL Tuning (Quest Central 套件) 可自動分析 SQL 效能、產生等價優化方案、並比對找出最佳寫法。
OPTION (FORCE ORDER) 等 Hint)。SELECT dbo.Person_BasicInfo.*,
dbo.Graduater_GraduaterRegist.RegistNO AS RegistNO,
...,
CASE WHEN dbo.Graduater_Business.ComeFrom = 'WS' THEN '網上登記'
WHEN dbo.Graduater_Business.ComeFrom = 'HP' THEN '華普大廈'
...
END AS ComeFromName,
...
FROM dbo.Person_BasicInfo
INNER JOIN dbo.Graduater_Business ON ...
LEFT OUTER JOIN dbo.Graduater_GraduaterRegist ON ...
INNER JOIN dbo.Person_Contact ON ...
INNER JOIN dbo.Person_Skill ON ...
INNER JOIN dbo.Person_EmployPurpose ON ...
OPTION (FORCE ORDER);