Skip to main content
Narrative I/O Knowledge Base home page
Search...
⌘K
Support
Open Narrative
Open Narrative
Search...
Navigation
Query Optimization
Query Optimization
Getting Started
Guides
Concepts
Reference
API Reference
Cookbooks
Release Notes
Overview
Guides
Data Ingestion
Hashing PII for Upload
Connecting data sources
Automated syncs
Schema changes
Querying with NQL
Filtering and Transforming Data
Joining Datasets
Creating Materialized Views
Incremental Upserts with MERGE ON
Query Optimization
Query Optimization
Avoid OR in JOIN Clauses
Troubleshooting
Data Collaboration
Sharing data
Access controls
Data products
Using Narrative ID
Rosetta Stone
Mapping Schemas
Validating Mappings
Handling Edge Cases
Best Practices
Query patterns
Governance
Security
Account Settings
API Keys
SSO Configuration
SDKs
SDK Guides
SDK Authentication
Executing NQL Queries
Managing Datasets
Uploading Data
Tracking Job Status
Error Handling
On this page
Prerequisites
Optimization guides
Related content
Query Optimization
Query Optimization
Copy page
Write faster, more efficient NQL queries
Copy page
Efficient queries are essential for working with large datasets in Narrative. This section covers optimization techniques and patterns to help your queries run faster and use fewer resources.
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
Incremental Upserts with MERGE ON
Avoid OR in JOIN Clauses
⌘I