Query plan variation

Hello all:
I have several databases (one per customer) on several different
servers. The servers and databases are alike in structure. However,
one of the databases is consistently coming up with different (and
slower) query plans than the others (which are consistent), even
disregarding the correct indices to use until a table hint is
provided, something the other databases are not needing. I repeat that
the databases all have an identical structure - except, I suppose, for
whatever is causing this behavior.
Can anyone point me in the direction of why this might be happening?
Thanks,
zdrakecStatistics? Radically different data?
http://msdn2.microsoft.com/en-us/library/aa260645(SQL.80).aspx
Just a thought. If that turns out to be it, maybe look into the Auto Update
Statistics option for the database.
//Andrew
> Hello all:
> I have several databases (one per customer) on several different
> servers. The servers and databases are alike in structure. However,
> one of the databases is consistently coming up with different (and
> slower) query plans than the others (which are consistent), even
> disregarding the correct indices to use until a table hint is
> provided, something the other databases are not needing. I repeat that
> the databases all have an identical structure - except, I suppose, for
> whatever is causing this behavior.
> Can anyone point me in the direction of why this might be happening?
> Thanks,
> zdrakec|||On Sep 4, 4:26 pm, Andrew Backer <awbac...@.gmail.com> wrote:
> Statistics? Radically different data?
> http://msdn2.microsoft.com/en-us/library/aa260645(SQL.80).aspx
> Just a thought. If that turns out to be it, maybe look into the Auto Update
> Statistics option for the database.
> //Andrew
>
> > Hello all:
> > I have several databases (one per customer) on several different
> > servers. The servers and databases are alike in structure. However,
> > one of the databases is consistently coming up with different (and
> > slower) query plans than the others (which are consistent), even
> > disregarding the correct indices to use until a table hint is
> > provided, something the other databases are not needing. I repeat that
> > the databases all have an identical structure - except, I suppose, for
> > whatever is causing this behavior.
> > Can anyone point me in the direction of why this might be happening?
> > Thanks,
> > zdrakec- Hide quoted text -
> - Show quoted text -
Thank you Andrew:
Well, the data is of course different, but only in details, not in
form, so not radically so. We have an app I wrote that updates the
statistics on all the databases on a regular basis, so I don't think
that is it either. However, I do believe that it has something to do
with the setup.
Thanks for you input,
zdrakec