Prerequisites
Before diving into optimization, you should have:- Basic familiarity with NQL syntax
- Understanding of JOIN operations
Optimization guides
Avoid OR in JOIN Clauses
Restructure OR conditions into single-key joins for dramatically better performance
Related content
Understanding JOIN Performance
Learn why certain JOIN patterns cause performance problems
NQL Functions Reference
Complete reference for NQL functions including UNNEST
Joining Datasets
Fundamentals of combining data from multiple datasets