Execution plans are generated by the database engine when you run a SQL query, either before or after the execution. They show you the logical and physical operations that the engine performs to ...

One of my friend asked me whether is it possible in SQL Server ... to find out how a query is behaving and relating with the database to fulfill its cause of execution. I am using a database here ...