-
Bit confused with Select Query
I am bit confused regarding below query .
select /*+ parallel_index(t,"IDX_CR_TRANSACTION_HIST_17",32) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring
no_expand index_ffs(t,"IDX_CR_TRANSACTION_HIST_17") */ count(*) as nrw,count(distinct sys_op_lbid(52330892,'L',t.rowid)) as nlb,count(distinct
hextoraw(sys_op_descend("SHADOW_ACCOUNT_NBR")||sys_op_descend("TRANSACTION_CODE")||sys_op_descend("REVERSAL_FLAG")||sys_op_descend("TRANSACTION_DATE"))
) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "POWERCARD"."CR_TRANSACTION_HIST" sample block ( 9.4648595205,1) t where
("SHADOW_ACCOUNT_NBR" is not null or "TRANSACTION_CODE" is not null or "REVERSAL_FLAG" is not null or "TRANSACTION_DATE" is not null) and
(TBL$OR$IDX$PART$NUM("POWERCARD"."CR_TRANSACTION_HIST",0,4,0,"ROWID") = bjn)
can you please confirm me whether this query is for statistics gathering query or not?
Regards
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|