Details:
https://docs.microsoft.com/zh-cn/previous-versions/sql/sql-server-2005/ms181714(v=sql.90)
Example:
SET STATISTICS PROFILE ON -- DISPLAY EXCUTION PLAN
SELECT ...
FROM ....
INNER JOIN ...
...........
OPTION ( FORCE ORDER); -- RUN AS PLANNED SEQUENCE
SET STATISTICS PROFILE OFF