DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Bit confused with Select Query

Hybrid View

  1. #1
    Join Date
    Apr 2009
    Posts
    54

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    That would be my guess.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width