B.U.M.P

Please forgive me for using old college technique to bring up my post!

I still would like to hear from others who experienced loss of
performance after backup, even to identical systems. Does the restored
db suppose to retain the same state of tune ( stats, data
fragmenetation) as the original, given identical system specs.  I mean
we should not have to to runstat or even the extreme makeover of reorg
tables follow each restore ?

By the way,

The new yahoo group bulletin include a lot more text and reduces the no
of posts visible on a page to just a handful. Often people lose
interest and not bother with clicking on "Older Topics" buttons. So
many recent posts get little visibility in my opinion, and sort of
defeat the purpose of a community forum. I have no problem with the old
format where they just list the headings. People learned to be creative
in supplying meaningful headings. Then you will see like 20 recent
topics on a page.

If you agree :), you can click on HELP and find 'Contact Us' button to
let your opinion know to Yahoo Groups.

Thank you.
Selma

If you need to do RUNSTATS and REBIND after a restore to repair
performance then I'd pull a copy of the statistics before & after
runstats and compare them. You've something strange going on. I'd also
figure out if its the same queries that have the performance issue and
do before & after explains to look at access paths.

Your hardware configurations may not be identical. The systems may have
different real memory or even different disc configurations! I've seen
cases where one system had a C: drive that was RAID5 while the backup
had RAID1. The database only saw a C: drive. CPU speeds may also be
different.

Phil Sherman