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