Re: Diff. Execution plan for 2 identical DB
From: David (david.parenteau_at_compuware.com)
Date: 08/26/04
- Next message: David: "Re: Diff. Execution plan for 2 identical DB"
- Previous message: Roji. P. Thomas: "Re: How to update @x table with a subquery?"
- In reply to: Eric Sabine: "Re: Diff. Execution plan for 2 identical DB"
- Next in thread: David: "Re: Diff. Execution plan for 2 identical DB"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 07:52:08 -0700
Yes, I executed UPDATE STATISTICS tableName for both
tables taht are involved.
I also executed DBCC DBREINDEX and CHECKDB
A thing: The statement that hangs is made from only 2
tables, but they are in the FROM 9 times each, they have 9
different alias. There is a lot of link between each of
them.
Does the number of tables could be the reason of failing
on a database and not in another similar? I would be
surprised...
TIA
>-----Original Message-----
>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
>
>
>.
>
- Next message: David: "Re: Diff. Execution plan for 2 identical DB"
- Previous message: Roji. P. Thomas: "Re: How to update @x table with a subquery?"
- In reply to: Eric Sabine: "Re: Diff. Execution plan for 2 identical DB"
- Next in thread: David: "Re: Diff. Execution plan for 2 identical DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
