Set an option that allows writing to temporary files in order to handle memory intensive queries.