Re: sql2k5 performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Yes, I update stats daily. The db is in 90 compatibility mode. The query
plans between Production (SQL2k) and Dev (SQL2k5) they look similar, but not
identical. However, the bulk of the cost is still in a clustered index scan
(yes, I know that's not optimal, but when the proc works in 1 second, I'm
not too concerned). I do see that the old query plan has parallelism, while
the new one does not. But since 0% of the cost is there I don't know if
this makes a difference or not. What specifically should I look for in the
query plan? And what is it about SQL 2k5 that would make this soooo much
slower? I'd really like to understand the difference.

Thanks, Andre


.

Relevant Pages

  • Re: How ">=" Work on Varchar field?
    ... country, olddonorid, sourceid ... This Gives the Below Execution Plan: ... > increasing the cost for the total plan to above the cost for simply ... depending on the rest of the query. ...
    (microsoft.public.sqlserver.programming)
  • Re: QUERY TUNING
    ... IN THE ABOVE QUERY I HAVE A NORMAL INDEX IN THE BRAN_CODE COLUMN.. ... THIS IS THE EXPLAIN PLAN OF THAT QUERY.. ... Cost  | ... Predicate Information: ...
    (comp.databases.oracle.server)
  • Re: QUERY TUNING
    ... IN THE ABOVE QUERY I HAVE A NORMAL INDEX IN THE BRAN_CODE COLUMN.. ... Cost  | ... statistics are not ran by default. ... Otherwise the explain plan can't be used. ...
    (comp.databases.oracle.server)
  • Re: QUERY TUNING
    ... IN THE ABOVE QUERY I HAVE A NORMAL INDEX IN THE BRAN_CODE COLUMN.. ... Cost  | ... Otherwise the explain plan can't be used. ...
    (comp.databases.oracle.server)
  • Re: Why is this
    ... would be to have a single index on (lastrecon, acctnum, deposit) [or ... cover the query and handle the restrictive condition immediately. ... there is no perfect query plan. ... use the index for TOP 1, even if it used quite a few bookmark lookups, ...
    (microsoft.public.sqlserver.server)