DB2 - L

 View Only
  • 1.  CTE Opthints - They are official!

    Posted Jun 24, 2022 01:09 AM
    WOW! After years of being hidden, CTE Opthints just got made IBM Official... Check out the, slightly late :), announcement in the Aha Idea from Walter:

    DB24ZOS-I-717

    Now we just have to wait for official docu... If you cannott wait for the official docu you can still read my Blog all about these fantastic beasts here:

    https://www.segus.com/2021-02-hidden-features-of-explain/

    If you ever wanted to lock a query to stop table access flips these are you go to fix!

    ------------------------------
    Roy Boxwell
    Software Engineering GmbH
    ------------------------------


  • 2.  RE: CTE Opthints - They are official!

    Posted Jun 28, 2022 11:10 PM
    "Now we just have to wait for official docu..."

    I did ask - however "the development team ... say that they would like to document CTE optimization hints at some point in the future. However, right now, the feature should be used under the direction of IBM support only."




    ------------------------------
    James Campbell
    ------------------------------



  • 3.  RE: CTE Opthints - They are official!

    Posted Jun 29, 2022 03:05 AM
    Great news! These things are super and when documented even better! Terry Purcell and I discussed them many moons ago...

    Roy Boxwell 


    SOFTWARE ENGINEERING GmbH and SEGUS Inc.
    -Product Development-
     


    IBM Champion 2022


    Vagedesstrasse 19
    40479 Dusseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: 
    R.Boxwell@seg.de
    Web  http://www.seg.de

    Link zur Datenschutzerklärung


    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert, Ulf Heinrich