Re: Oracle ignoring function-based index

From: Tarby777 <nick_williamson_at_mentorg.com>
Date: 25 Jul 2005 07:43:20 -0700
Message-ID: <1122302600.717250.70510@g44g2000cwa.googlegroups.com>

Well, things are looking up - the CBO is running well and a script I'm working on is down from 14 hours to 30 minutes as a result. One final thing, the params I'm passing into the stats routine are as per something I found on the net:

exec dbms_stats.gather_schema_stats( -

      ownname => 'HSE', -
      estimate_percent => 0.5, -
      method_opt => 'FOR ALL COLUMNS SIZE 1', -
      degree => 8, -
      granularity => 'ALL', -
      options => 'GATHER STALE', -
      cascade => TRUE -

);

...are those reasonable values to run with?

TIA
Nick Received on Mon Jul 25 2005 - 09:43:20 CDT

Re: Oracle ignoring function-based index - why?