dbms_stats using no_parallel_index internally

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 29 Mar 2006 12:26:20 -0800 (PST)
Message-ID: <20060329202620.47450.qmail@web52813.mail.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") */

       COUNT (DISTINCT sys_op_lbid (8753663, 'R', t.ROWID)) AS nrw,

       COUNT (DISTINCT sys_op_lbid (8753663, 'L', t.ROWID)) AS nlb,

       COUNT (DISTINCT "DATE_KEY") AS ndk, NULL AS clf   FROM "D1"."D1_FACT" t
 WHERE tbl$or$idx$part$num ("D1"."D1_FACT", 0, 3, 0, "ROWID") = :objn

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Wed Mar 29 2006 - 14:26:20 CST