It looks like you have a partitioned table with a parallel or parallel index definition. The :Qxxxxyyy are the 'table queues' used by parallel query slaves to pass messages between the layers of slaves operating the query. The SQL with the hints in it is the SQL generated by the query co-ordinator as it breaks down your original query for parallel execution. I don't think that tkprof makes a very neat (or complete) job of presenting such query plans, but it is quite hard to do anything good when they get complex. I tend to run my own 'explain plan' script (see the website noted below) to split the parallel query SQL from the rest of the plan as this tends to make things a little cleaner. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html For latest news of public appearances See http://www.jlcomp.demon.co.uk Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. -----Original Message----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 27 August 2001 19:22 |I am running tkprof and explain plan on the following SQL statement: | |SELECT DISTINCT CNFR_NO, |SPLT_PAY_TYPE, ACH_AMT |FROM whse_dbo.ACH_TRAN |WHERE ACCT_NO = '46807' AND | TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND | STATUS = '2' AND | CNFR_NO >0 AND | (SPLT_PAY_TYPE = '810' OR | SPLT_PAY_TYPE = '820' ); | |I'm not really looking for advice on tuning this query but rather just |wanted to have some general questions answered regarding the |results i got using tkprof. | |This is the first time I've ever run tkprof on a statement and gotten |an explain plan with :Q in it (followed by numbers). What does the |:Q mean? | |Also, there is not hint embedded in the select statement I ran but |the explain plan output shows hints in the explain plan. Or at least |the explain plan list the output in hint format. Why is it doing that, |when there were no hints in the original source? | |Thanks in advance, | |Cherie Machler |Oracle DBA |Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
