What do you mean by an execution plan? Why is it used?
- 1 Answers
- 1102 Views
- I also Faced
- E-Mail Answers
Answer Posted / Pramod Kumar Kesarwani
{"execution_plan": "A set of steps that SQL Server follows to execute a query or update statement. It outlines the operations required, such as scans, seeks, joins, and sorts, as well as their sequence and estimated costs."n n "used": "Execution plans are used to understand the performance of queries, optimize them, and identify bottlenecks in database applications."]}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we solve concurrency problems?
What are the source of constraints?
What are the properties of the transaction?
Can one drop a column from a table?
Explain system functions or built-in functions? What are different types of system functions?
Why use identity in sql server?
How do I start sql server 2017?
List the ways in which dynamic sql can be executed?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain “row_number()” in sql server with an example?
Disadvantages of the indexes?
How to connect php with different port numbers?
How to rebuild the master database?
What are the kinds of subquery?
