Reindexing can cause slowness?

I have a database that I recently reindexed (all tables) and users are
complaining of slow report performance. What could cause this? Is it updating
statistics some how? Or rebuilding the cache?
I ran the same complaint reports on the same database on another server that
was not reindexed and the reports ran just fine.
Auto update and auto create statistics are checked in the above databases.
Thank you in advance.
--
Message posted via http://www.sqlmonster.comDid you check (and compare!) execution plans on each server?
A
"fnadal via SQLMonster.com" <u10790@.uwe> wrote in message
news:7d53e85ad059a@.uwe...
>I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.sqlmonster.com
>|||I was able to get statistics on the query on the database that completes the
query, I'm still waiting for the query to complete on the problem database...
I'll post when finished.
Aaron Bertrand [SQL Server MVP] wrote:
>Did you check (and compare!) execution plans on each server?
>A
>>I have a database that I recently reindexed (all tables) and users are
>> complaining of slow report performance. What could cause this? Is it
>[quoted text clipped - 8 lines]
>> Thank you in advance.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1|||Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics go
out of sync with the index information and degrade performance.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via SQLMonster.com" wrote:
> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.sqlmonster.com
>|||If you rebuild an index, the stats are updated automatically.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:23D02E88-B53F-415C-9DF8-571EC80004B4@.microsoft.com...
Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics
go
out of sync with the index information and degrade performance.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via SQLMonster.com" wrote:
> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.sqlmonster.com
>