What is server execution plan ? what is the use of it ?

Hi,

the server execution is created by the server to plan the gathering and
querying of the data. You don=B4t have to "use" it. In sql server 2000
you can view the estimated execution plan and in sql server 2005
additionally the "real" in the GUI in QA to see where you might have
problem in your database design. Therefore with changing your query you
can change the execution plan.

HTH, Jens Suessmeyer,

---
http://www.sqlserver2005.de
---