on 11-13-2008 7:46 PM
During a reorganization of tables via BRTools / BRSpace, Is it possible to have database statistics recalculated for tables at the same time, without re-reading all the data to perform a separate analyze?
We are using Oracle 10.2.0.2.
I agree.
but recalculating stats after can be done quickly:
brconnect -c -u / -f stats -t missing
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to all that have responded. I understand that there will be some quirks concerning parameter settings for BRCONNECT (missing / collect) due to statistics being backed up before the reorg and then restored afterward.
Based on the responses so far, it seems that there is no way to avoid re-reading the tables a second time (i.e. once for the reorg and once for the statistics). Hopefully I can at least skip the indexes, as the reorg is supposed to calculate statistics during the reorg when the indexes are moved/rebuild.
James
Given my own research and the thoughts provided by others, I think the answer to my question is "you can't", which is unfortunately. However, that seems to be the answer, so I am marking this question as such.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi james,
i don't think so. from my point of view, that after you reorganize your database, you'll need to update database statistics again since your latest database statistics was done before your database is reorganize. i am sure that it has significant different.
that's my opinion.
ardhian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.