Improving the Performance of SQL Queries
You can improve the performance of queries over maps by indexing map entries and making sure that the most queried entries are stored on the same member.
To find out more about indexing map entries, see Indexing Maps.
To find out more about making sure certain map entries are stored on the same member, see Data Affinity.
If you find that your queries lead to out of memory exceptions (OOME), consider decreasing the value of the Jet engine’s maxProcessorAccumulatedRecords option.