Untitled Flashcards

Front

What is the role of the Relational Engine in SQL Server?

Back

The Relational Engine processes SQL queries.

It includes:
- Query Parser: checks if the SQL syntax is correct.
- Query Optimizer: creates the best plan to run the query (called Execution Plan).
- Query Executor: follows that plan to run the query step by step and gets data from storage.

Front

What is an Execution Plan and how does it impact queries?

Back

An Execution Plan is like a roadmap that tells SQL Server how to run a query.

It decides which steps to take, what order, and how to get the data.

A good Execution Plan helps the query run faster and use fewer resources, while a bad plan may slow down performance.