Re: Weird speed problem

DBMonitor (spamawayau@xxxxxxxxxxxx) writes:
Both query plans use indexes on for both the tables though. The plans
are almost identical.

"Almost". Apparently, there is a subtle, but important difference.

Would it be posible for you to post the query plans? If you are on SQL 2005
you can save the graphical execution plan in a file and post that in an
attachment. (Or put it on a web site with a link to it.)


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Writing updates from a wide DataTable
    ... SQL Server will also cache query plans for parameterized queries. ... too many i.e. not effectively caching very well. ...
    (microsoft.public.dotnet.framework.adonet)
  • 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: view object
    ... It is dangerous and a sure fire way to ... It is the query plans that make the view or ... slowing if not stopping SQL. ... Save HOURS documenting your SQL Server! ...
    (microsoft.public.sqlserver.programming)
  • Re: a question or two re fulltext queries
    ... Looking for a SQL Server replication book? ... one of which involves a fulltext index on a related table. ... i discovered today that a less selective CONTAINSclause: ... i examined the query plans and discovered that in the bad case the first ...
    (microsoft.public.sqlserver.fulltext)
  • a question or two re fulltext queries
    ... i'm using SQL Server 2000 ... i am looking at SQL for finding documents based on a couple of ... one of which involves a fulltext index on a related table. ... i examined the query plans and discovered that in the bad case the first ...
    (microsoft.public.sqlserver.fulltext)