[QUOTE][i]Originally posted by jdorlon [/i]
[B]

with each table in the tablespace, do this :

analyze table x compute statistics;
(it will do the indexes automatically when you do the tables) [/B][/QUOTE]

is this the same as running
1) -checkopt
2) -analyze