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 |
|
nikita
Starting Member
7 Posts |
 Posted - 2007-12-24 : 03:09:02
|
| Hi,I have got a couple of queries. I have to optimize them to get best performance.Is there any tool in the market (even paid) which helps in rewriting the query (best performance)thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-24 : 03:37:07
|
| The starting point for this will be to run the query with "show actual execution plan" enabled in SSMS, identify costly steps and try to optmize costly steps (like including new indexes to remove table scan). You can also use database tuning wizard tool in SSMS to optimize your queries. |
 |
|
|
nikita
Starting Member
7 Posts |
Posted - 2007-12-24 : 03:40:52
|
| i have done all that..created indexes and statistics..etc etc..just needed a tool which can display 'options' of rewriting the query as in to get maximum performancethank you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-24 : 04:57:49
|
| I dont think you have a tool that gives you direct options of optimised query. All that you need to do is an analysis of your written query with the help of tools like query execution plan,SQL profiler and DB Tuning wizard and trying rewriting it based on suggestions/recommendations given by them. |
|
|
|
|
|
|
improving performance of query