Enable Join Spill

Hi anyone can tell me how to enable a join spill for a specific query in vertica with example.

Thanks in advance


  • scottpedersoliscottpedersoli Vertica Customer

    Place this directly after the statement (DELETE/MERGE/UPDATE/INSERT) ...
    /+ set_vertica_options(EE, ENABLE_JOIN_SPILL)/

  • Dave_StewartDave_Stewart Vertica Customer

    Don't forget asterisks ! :

    /*+set_vertica_options(EE, ENABLE_JOIN_SPILL)*/

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file