|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Where to learn how to read the query execution plan?I'm wondering why (book, website etc...) could I learn how to read the query
execution plans and subsequently modify to enhance the performance of the queries. Thanks for you reply. -- Regards, Pedestrian, Penang. Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 Hi,
The best source I have seen for this topic is the book 'Inside SQL Server 2005: Query Tuning and Optimization' by Kalen Delaney et al. It has two great chapters with more than 170 pages dedicated to this topic. Hope this helps, Ben Nevarez Senior Database Administrator AIG SunAmerica Show quote "pedestrian via SQLMonster.com" wrote: > I'm wondering why (book, website etc...) could I learn how to read the query > execution plans and subsequently modify to enhance the performance of the > queries. > > Thanks for you reply. > > -- > Regards, > Pedestrian, Penang. > > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 > > Hi, thanks very much.
Ben Nevarez wrote: Show quote >Hi, > >The best source I have seen for this topic is the book 'Inside SQL Server >2005: Query Tuning and Optimization' by Kalen Delaney et al. It has two great >chapters with more than 170 pages dedicated to this topic. > >Hope this helps, > >Ben Nevarez >Senior Database Administrator >AIG SunAmerica > >> I'm wondering why (book, website etc...) could I learn how to read the query >> execution plans and subsequently modify to enhance the performance of the >> queries. >> >> Thanks for you reply. -- Regards, Pedestrian, Penang. Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 On Nov 26, 9:24 am, "pedestrian via SQLMonster.com" <u16758@uwe> This will give you a good start.wrote: > I'm wondering why (book, website etc...) could I learn how to read the query > execution plans and subsequently modify to enhance the performance of the > queries. > > Thanks for you reply. > > -- > Regards, > Pedestrian, Penang. > > Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 http://blogs.msdn.com/craigfr/archive/tags/Scans+and+Seeks/default.aspx. Thanks Shiju Samuel Thanks for provide easy access resource.
Shiju Samuel wrote: Show quote >On Nov 26, 9:24 am, "pedestrian via SQLMonster.com" <u16758@uwe> >wrote: >> I'm wondering why (book, website etc...) could I learn how to read the query >> execution plans and subsequently modify to enhance the performance of the >[quoted text clipped - 7 lines] >> >> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 > >This will give you a good start. >http://blogs.msdn.com/craigfr/archive/tags/Scans+and+Seeks/default.aspx. > >Thanks >Shiju Samuel -- Regards, Pedestrian, Penang. Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 It is interesting to note that Shiju recommended the Craig Freedman's SQL
Server Blog and the 2 chapters from the book I recommended, one is written by Craig Freedmand and the second one is written by both Kalen Delaney and Craig Freedman. Ben Nevarez Senior Database Administrator AIG SunAmerica Show quote "pedestrian via SQLMonster.com" wrote: > Thanks for provide easy access resource. > > Shiju Samuel wrote: > >On Nov 26, 9:24 am, "pedestrian via SQLMonster.com" <u16758@uwe> > >wrote: > >> I'm wondering why (book, website etc...) could I learn how to read the query > >> execution plans and subsequently modify to enhance the performance of the > >[quoted text clipped - 7 lines] > >> > >> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 > > > >This will give you a good start. > >http://blogs.msdn.com/craigfr/archive/tags/Scans+and+Seeks/default.aspx. > > > >Thanks > >Shiju Samuel > > -- > Regards, > Pedestrian, Penang. > > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1 > > Yeah correct. I highly recommend all the four books of Inside SQL
server 2005. To understand the Plan you should read the 3rd chapter of T-SQL Querying before 3rd and 4th chapter of Query Tuning and Optimization. Thanks Shiju Samuel. Hi, thanks for both of you to provide these additional information.
Shiju Samuel wrote: Show quote >Yeah correct. I highly recommend all the four books of Inside SQL >server 2005. To understand the Plan you should read the 3rd chapter of >T-SQL Querying before 3rd and 4th chapter of Query Tuning and >Optimization. > >Thanks >Shiju Samuel. -- Regards, Pedestrian, Penang. Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1  |
|||||||||||||||||||||||
Other interesting topics