You can use the SET OPTIMIZATION LEVEL statement:

    o  In interactive SQL

    o  Embedded in host language programs to be precompiled

    o  In dynamic SQL as a statement to be dynamically executed