Re: Urgent Request
Date: Tue, 26 Feb 2008 13:59:12 GMT
Message-ID: <QWUwj.8039$xq2.6263@newssvr21.news.prodigy.net>
In article <e3cf774b-d243-49e4-9436-48cca738879e_at_e6g2000prf.googlegroups.com>, Smitty <marksmithy69_at_hotmail.com> 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