Re: Diff. Execution plan for 2 identical DB

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

From: Eric Sabine (mopar41_at_hyotyt_mail_nounderscores.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 10:34:18 -0400

Have you tried updating the statistics yet?

David wrote:
> Hi!
>
> I'm experiencing something strange... I have 2 databases
> who have the same indexes but when I execute a query on
> both, the first DB is fast but the second hangs... The
> execution plan are significally different for some tables
> that have the same indexes...
>
> I really need help to go forward. Somebody could help me
> in which way to look for?
>
> David

Relevant Pages

  • Re: Optimizing inline view
    ... Charles Hooper wrote: ... execute the following before processing your query, ... I updated the statistics on this table and the thing ... If you are still having problems, execute the three ALTER SESSION ...
    (comp.databases.oracle.misc)
  • Re: Finally which ORM tool?
    ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clarification on DBI module
    ... You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. ... The sql query can have bind variables or they may not have. ... Ahhh...imagining that irresistible "new car" smell? ...
    (perl.dbi.users)
  • RE: Running action function from SELECT query
    ... Yes ADO can execute queries saved in an Access database. ... I do not know how ADO.NET works, but the developer tells me he is able to ... At any rate, I can call just a function from a query, like this: ...
    (microsoft.public.access.modulesdaovba)