db2 runstats

[janagana]

What is the equivalent of db2 runstats in oracle ? is there any?

if not, how does oracle do query optimization

Thanks
--
Posted via http://dbforums.com

[s.kapitza]

Hi,

search for "analyze" in Oracle Groups

regards

s.Kapitza

janagana <me*********@dbforums.com> wrote in message news:<32****************@dbforums.com>...

What is the equivalent of db2 runstats in oracle ? is there any?

if not, how does oracle do query optimization

Thanks

[Michael Willer]

s.kapitza wrote:

Hi,

search for "analyze" in Oracle Groups

regards

s.Kapitza

janagana <me*********@dbforums.com> wrote in message news:<32****************@dbforums.com>...

What is the equivalent of db2 runstats in oracle ? is there any?

if not, how does oracle do query optimization

Thanks

Not sure what runstat is precisely but:

- STATSPACK, will give you valuable data regarding instance performance
(Check "Oracle Supplied packages" and "Performance reference" for
more information

- IF you "analyze" you tables, indexes,... you'll get information on
data distribution, number of rows. For indexes also B-Tree height a.s.o.
Again "Performance Reference" is a place to look plus naturally
"Database Administrators Guide"
Michael Willer
Cybercom Group