Re: dbms_stats using no_parallel_index internally

If you are on Oracle 10
AND
you are adventurous
you could set _optimizer_ignore_hints to true.

Although I suppose Oracle has a reason for explxitly putting the no_parallel_index hint in the sql.

Quoting Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>:

> Even with specifying DEGREE=4, the dbms_stats
> internally generates this Hint to use
> no_parallel_index when processing the Indexes for the
> table being analyzed. Any ways to force it to use
> parallel or NOT TO USE no_parallel_index hint? I have
> tried 'alter session enable parallel query', but still
> produced the same.
>
> SELECT /*+ no_parallel_index(t,"DT_P_BIX") dbms_stats
> cursor_sharing_exact use_weak_name_resl
> dynamic_sampling(0) no_monitoring no_expand
> index(t,"DT_P_BIX") */

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l