Re: Urgent Request

From: joel garry <>
Date: Tue, 26 Feb 2008 10:43:51 -0800 (PST)
Message-ID: <>

On Feb 25, 5:16 pm, 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.

How exactly are you replicating? Is it the original or replicant that is slow? How are you determining the indices are identical? What exact version/platform are you on?

Also see

(And a gentle reminder to use descriptive subject lines in the future.)


-- is bogus.
Received on Tue Feb 26 2008 - 12:43:51 CST

Original text of this message