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
0
Hi anyone can tell me how to enable a join spill for a specific query in vertica with example.
Thanks in advance
Comments
Place this directly after the statement (DELETE/MERGE/UPDATE/INSERT) ...
/+ set_vertica_options(EE, ENABLE_JOIN_SPILL)/
Don't forget asterisks ! :
/*+set_vertica_options(EE, ENABLE_JOIN_SPILL)*/