Re: Urgent Request

From: Doug Miller <>
Date: Tue, 26 Feb 2008 13:59:12 GMT
Message-ID: <QWUwj.8039$>

In article <>, Smitty <> wrote:
>Hello everyone. I am really hoping that someone can help me with this
>issue. I have two identical databases (one is a replication of the
>other), where when I run an identical query on each, one returns the
>results in .5 seconds, while the other takes 18 seconds to return the
>same result. The indexes etc. are all identical on each database.
>When we ran a trace, we noticed that the disk gets hit only once on
>the 'quick' database, but get hit over 10000 times on the 'slow'
>database to return the same number of rows. Does anyone have any idea
>what could be the issue. I am attaching the query below. Thank you
>very much.

Statistics haven't been updated recently on the 'slow' database? Received on Tue Feb 26 2008 - 07:59:12 CST

Original text of this message