Hi,

 

With the following plan:

PLAN SORT (JOIN (T T TL INDEX (TICKETLABELSTICKETTID)) PLAN (T T L NATURAL), L INDEX (TICKETLABELID))

 

Is the second PLAN expression is nested stream in the first SORT?

 

eg:

PLAN SORT (

    JOIN (

        T T TL INDEX (TICKETLABELSTICKETTID)

    )

    PLAN (

        T T L NATURAL

    ),

    L INDEX (TICKETLABELID)

)

 

And how about the final INDEX specifier?

 

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!