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
-
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
-
Re: db2 runstats
Hi,
search for "analyze" in Oracle Groups
regards
s.Kapitza
janagana <member36565@db forums.comwrote in message news:<3271945.1 061504903@dbfor ums.com>...What is the equivalent of db2 runstats in oracle ? is there any?
>
>
>
if not, how does oracle do query optimization
>
>
>
Thanks -
Re: db2 runstats
s.kapitza wrote:Not sure what runstat is precisely but:Hi,
>
search for "analyze" in Oracle Groups
>
regards
>
s.Kapitza
>
janagana <member36565@db forums.comwrote in message news:<3271945.1 061504903@dbfor ums.com>...
>>>What is the equivalent of db2 runstats in oracle ? is there any?
>>
>>
>>
>>if not, how does oracle do query optimization
>>
>>
>>
>>Thanks
- STATSPACK, will give you valuable data regarding instance performance
(Check "Oracle Supplied packages" and "Performanc e 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 "Performanc e Reference" is a place to look plus naturally
"Database Administrators Guide"
Michael Willer
Cybercom Group
Comment
Comment