Improving the Performance of SQL Queries
You can improve the performance of queries over maps by indexing map entries.
To find out more about indexing map entries, see Indexing Maps.
If you find that your queries lead to out of memory exceptions (OOME), consider decreasing the value of the Jet engine’s maxProcessorAccumulatedRecords option.