What is excution Plan in sql server

Answer Posted / cla

A query execution plan outlines how the SQL Server query optimizer actually ran or possibly run a query

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

629


How to choose all records from the table?

649


How to concatenate two binary strings together?

607


what is a correlated sub-query? : Sql server database administration

482


Indexes are updated automatically is the full-text index also updated automatically?

621






What is subquery in sql?

566


What is @@error in sql?

619


Explain what role entity and relationship play in an ER diagram.

571


What is Transparent Data Encryption?

585


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

557


Explain the different types of joins?

566


where can you add custom error messages to sql server? : Sql server administration

577


Define Wed Edition in SQL Azure?

80


What is the distinction amongst delete and truncate?

583


What is the bookmark lookup and rid lookup?

566