Re: Analysing Execution plan

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 03/22/04


Date: Mon, 22 Mar 2004 15:47:15 +0530

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
"Ramnadh" <anonymous@discussions.microsoft.com> wrote in message
news:1109c01c40fdb$a75b00b0$a501280a@phx.gbl...
> 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,
> Ramnadh.


Relevant Pages

  • Re: query performance help needed
    ... Whether the execution plan is there or not has little do with it. ... It's very clear that you need to analyse your query plans, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... What you said was what I first planned to say, but then I read the Books Online which implies that the batch is indeed reused, so I held back from saying that. ... the query optimizer will probably match the Transact-SQL statement in the second execution with the execution plan generated for the first execution. ... SQL Server does not have to compile the second statement." ...
    (microsoft.public.sqlserver.tools)
  • Re: Interpreting the execution plan results
    ... > On Query Analyzer.. ... > I can figure out a little what the information on the execution plan means ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Multicolumn correlated subquery?
    ... they had no effect on the execution plan or performance. ... situations where such "meaningless" permuation affected the query plan, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... Does SQL Server have trouble when a single table is this size? ... About 20 minutes into the query everything goes bad. ... >> go over some threshold, which seems to vary, the disk queue length ... >> I'll work on getting the real execution plan, ...
    (microsoft.public.sqlserver.programming)