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

Thread: Parallel Query

  1. 01-21-2003, 11:44 PM #1
    bse
    bse is offline Junior Member
    Join Date
    Dec 2002
    Posts
    4

    Parallel Query

    Is there anyway to enable parallel execution at the statment level when more than one table is involved in the query (ie. join)? I
    don't want to set the parallelism at the table level.

    Typically, a hint can be included to enable parallelism at the statement level (ie. SELECT /*+ PARALLEL (table1, 4) */ ), but how can this be enabled for EACH table in the FROM clause?

    Thanks.
    Reply With Quote Reply With Quote
  2. 01-22-2003, 04:15 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    when one table is parallelized then all involved tables are as well
    Reply With Quote Reply With Quote
  3. 01-22-2003, 04:42 AM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    bse, you can /*+ PARALLEL(table1,4) PARALLEL(table2,2) etc */

    pando, I don't think that can be right. If it was you wouldn't see PARALLEL_FROM_SERIAL in an explain plan.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  4. 01-22-2003, 04:54 AM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    http://asktom.oracle.com/pls/ask/f?p...arallelized%7D
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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