Groups | Blog | Home
all groups > sql server programming > march 2004 >

sql server programming : Analysing Execution plan


Ramnadh
3/21/2004 11:02:35 PM
Hi,

I am new in the SQL Server 2000. As i am writing the
Stored Procedures for the tables that contains millions of
rows in them those stored procedures were taking lot of
time. To evaluate where the time is taking, i doesn't
understand the Query execution plan properly. can anyone
suggest me the best lesson or document we have in
explaining the execution plan.

Regards,
Dragan Babovic
3/21/2004 11:16:06 PM
Ross McKay
3/22/2004 8:02:00 AM
[quoted text, click to view]

MSDN has some words on it here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_1pfd.asp

( http://tinyurl.com/2kfyo )

The book below isn't bad. It takes you through step by step, explaining
differences in the plan as it goes.

"SQL Server Query Performance Tuning Distilled", Sajal Dam
http://www.curlingstone.com/7029/7029book.html
--
Vinodk
3/22/2004 3:47:15 PM
Get online at the US WebCasts presented. We have a talk on Execution Plans
....

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp


[quoted text, click to view]

AddThis Social Bookmark Button