From: no.spam@please.com   
      
   s.kapitza wrote:   
   > Hi,   
   >   
   > search for "analyze" in Oracle Groups   
   >   
   > regards   
   >   
   > s.Kapitza   
   >   
   > janagana  wrote in message news:<327   
   945.1061504903@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)