does analyse schema has any performance gain for tables in locally manage tablespace?

[ngwh]

hi,

I am wondering if all my tablespaces are already in locally-managed mode would there be any performance gain runnning Analyse_schema or gather_schema_stats ???

appreciate any feedback.

[pando]

First, RTFM and see why you need to gather statistics

Second, statistics has nothing to do with tablespaces

[Axr2]

Originally posted by ngwh
I am wondering if all my tablespaces are already in locally-managed mode would there be any performance gain runnning Analyse_schema or gather_schema_stats ???

Aah..wish you'd posted this question a little earlier; so I'd have saved my breath on the "recover database" question of yours..

[ngwh]

hi pando,

any advice as to where i can read more about purpose of gathering statistic? i thot it has somethg to do with performance?

[ngwh]

axr2,

huh? wat's my latest posting gotta do with 'recovery' ??

anyway does any1 know whether performing a gather_schema_stats will takeup and tablespace? especially SYSTEM ts??

thanks

[abhaysk]

PT