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 |
|
mapidea
Posting Yak Master
124 Posts |
 Posted - 2009-09-09 : 18:48:35
|
| If we have a poor performing query. What could be the possible reasons.I could think of the following- Not having Clustered and Non Clustered index- Tables not properly normalized and DenormalizedWhat else could be the reason. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-09-09 : 20:23:53
|
| Without seeing the actual query, we'd just be grasping at straws...=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2009-09-09 : 22:21:30
|
| Thanks for your reply.I don't have a query which I want to optimize. I am looking for the general steps to be followed when optimizing queries. What are areas we can look at. Example - Not having Clustered and Non Clustered index- Tables not properly normalized and DenormalizedWhat else can be considered |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2009-09-10 : 01:52:19
|
| The way u write ur sql query.PBUH |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-09-10 : 14:26:48
|
| You can start with looking at the Execution Plan for your query. It should show you which tables are in need of index changes and, in SQL 2008, will give you the CREATE statement for grossly missing indexes.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
|
|
|
|
Poorly performing Stored Proc