Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-11-11 : 05:12:44
|
| I am using the EX plan to see the performance of the queries.Is it best to have the Cost to be as high as possible? For example My table has a clustered index which is used in the where clause. This gives a cost of 99%. Then when I add a non-clustered index which is another field used iin the where clause then EX plan Cost goes down to 96%Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-11 : 13:44:01
|
| If you add up all of the items in the execution plan, they will always total 100%.Tara |
 |
|
|
|
|
|
EX Plan (Performance)