Re: db2 runstats
From: Michael Willer <no.spam_at_please.com>
Date: Fri, 19 Sep 2003 12:54:03 +0200
Message-ID: <3f6ae075$0$13180$edfadb0f_at_dread15.news.tele.dk>
Date: Fri, 19 Sep 2003 12:54:03 +0200
Message-ID: <3f6ae075$0$13180$edfadb0f_at_dread15.news.tele.dk>
s.kapitza wrote:
> Hi,
>
> search for "analyze" in Oracle Groups
>
> regards
>
> s.Kapitza
>
> janagana <member36565_at_dbforums.com> wrote in message news:<3271945.1061504903_at_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
Received on Fri Sep 19 2003 - 12:54:03 CEST