Is it possible there is a full analyze running on the database? You said
you did
a reorg this weekend. If you bounced it 4 times it could be going through
backout
and recovery. Either one would keep it pretty busy.
R. Smith
-Original Message-
Sent: Tuesday, September 03, 2002 4:08 PM
if exp/imp were used Ensure that Statistics are DELETED ( RE-Created , if needed) as
they will be highly incorrect
Check for DEGREE 1 of the Tables Indexes . This will also Cause Optimizer to
choose BAD Plans if NO Statistics Exist
-Original Message-
Sent: Wednesday, September