Re: Seeing if there is Parallel Execution from tkptof output.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 31 May 1999 21:19:50 +0100
Message-ID: <928182233.6651.0.nnrp-08.9e984b29@news.demon.co.uk>

If this is oracle 7, then you cannot get parallel execution whilst driving off an index, so this specific example could not show a parallel display.

In version 8, you can get parallel execution driving off an index, but only if the table/index is suitably partitioned table so that each PQ slave can use a separate partition of the index.

In later versions of 7, if this example switched to a parallel tablescan you would see things like:

Rows Execution Plan
------- ---------------------------------------------------

      0  SELECT STATEMENT   GOAL: CHOOSE
      1   TABLE ACCESS FULL OF 'DBSTRUCT'
              SELECT /*+ ROWID (A1) */ C0 C0, C1 C1, C2 C2 FROM (
               SELECT C0, C1, C2 FROM DBSTRUCT A1
                WHERE A1.ROWID BETWEEN :b1 AND :b2
              )

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Mon May 31 1999 - 15:19:50 CDT