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

Thread: Parallel Query

  1. #1
    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    when one table is parallelized then all involved tables are as well

  3. #3
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

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