Give answer for the below question and justify the answer.


You are developing several new stored procedures on an existing SQL Server 2000 database and are experimenting in a Query Analyzer session with the individual queries to be used in these procedures. After running a given SELECT query and using the Graphical Showplan feature to understand the execution plan, you want to prove that internal statistics are available for a particular column used in the query. How would you best find this information?

(A). Disable the graphical showplan display.
(B). Hold the mouse over each individual node in the graphical plan relating to the desired column.
(C). Use a SET SHOWPLAN statement.
(D). Examine each individual node in the graphical plan relating to the desired column without mousing over it.