EXPLAINing plans

  • Comments posted to this topic are about the item EXPLAINing plans

  • Good question to start the week thanks Steve.

    ...

  • Interesting question.

    It seems odd that EXPLAIN can't be used with MERGE statements.

    Tom

  • Nice question, thanks Steve
    I remember using EXPLAIN while coding in DB2 on a Z/OS mainframe in the '90's.

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Stewart "Arturius" Campbell - Monday, September 25, 2017 10:55 PM

    Nice question, thanks Steve
    I remember using EXPLAIN while coding in DB2 on a Z/OS mainframe in the '90's.

    Someone must have used DBCC TIMEWARP to provide you with Z/OS in the '90s.   It wasn't released until the end of March 2001 (Z/OS V1 R1 release) and wasn't even announced until October 2000 (I guess some people may have got hold of a pre-release version, but surely not befoe the product was announced).

    Tom

  • TomThomson - Tuesday, September 26, 2017 5:14 AM

    Stewart "Arturius" Campbell - Monday, September 25, 2017 10:55 PM

    Nice question, thanks Steve
    I remember using EXPLAIN while coding in DB2 on a Z/OS mainframe in the '90's.

    Someone must have used DBCC TIMEWARP to provide you with Z/OS in the '90s.   It wasn't released until the end of March 2001 (Z/OS V1 R1 release) and wasn't even announced until October 2000 (I guess some people may have got hold of a pre-release version, but surely not befoe the product was announced).

    I started using it in late 1999 (could have been a beta or pre-release version, can't remember - actually, that might explain some of the issues we encountered then, now that i think of it)

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply