[firebird-support] Plan question, what is a stream and what isn't?

['Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]]

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!