Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Andrew Ford — — source: IIUG Forums & Mailing Lists
I'm performing in-place upgrades from 11.50 and 11.70 to 12.10 and I am
interested in the best way to drop and recreate distributions to minimize
impact.
Would this be the most reasonable approach?
for each table:
update statistics for table <table> drop distributions only;update statistics medium for table <table> distributions only; -- to quicklyput SOME reasonable distributions in place
-- do my normal update statistics from Art's dostats
update statistics low for table <table> (<columns>);update statistics high for table <table> (<columns>) distributions only;update statistics medium for table <table> (<columns>);
Thanks,
Andrew
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.