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 |
|
jeein1985@yahoo.co.in
Starting Member
2 Posts |
 Posted - 2009-02-13 : 03:53:43
|
| Hi Experts,How to Manually implement Query Optimization in SQL Server 2005.Is there any way to implement this and how. I am routed to implement Query optimization in SQL server 2005 using(i) Index intersection (ii)Cross ProductsAny Help would be highly appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-13 : 04:12:00
|
First learn to read execution plans.Then learn to read results from SQL Profiler.And in some months, you will have the skill to perform manual optimization for queries.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
jeein1985@yahoo.co.in
Starting Member
2 Posts |
Posted - 2009-02-13 : 04:17:04
|
| Thanks Peso,Is there any easy material to learn Execution plans. Please suggest me.Thanks once again |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-13 : 04:20:45
|
http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Query Optimization