I want to check the estimated number of rows of a query in MS SQL Server. I can right click on the query and select "display estimated execution plan". but I want to do the exact thing with a hard code query. Is there any way to do this without using the GUI?
This will give the XML, and you should be able to see the Estimates in there.
|show 1 more comment|
Use the DMV query: