How can I know if the query optimizer within SQL Server 2005 use any index or not in response to

Hi, all,

Would please any expert here give me any guidance and advices for how can I know if the query optimizer within SQL Server 2005 use any index or not in response to a query?

Thanks a lot in advance for that.

With best regards,

Yours sincerely,

Use SET STATISTICS PROFILE or SET SHOWPLAN XML to identify the indexes used in the query plan.

HTH!
--R