dbms_stats using no_parallel_index internally
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Mar 2006 12:26:20 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
