Skip to main content
Narrative I/O Knowledge Base home page
Search...
⌘K
Ask AI
Support
Open Narrative
Open Narrative
Search...
Navigation
Query Optimization
Query Optimization
Getting Started
Concepts
Guides
Cookbooks
Reference
API Documentation
Release Notes
Overview
Guides
Platform
Using the Context Selector
Data Ingestion
Hashing PII for Upload
Querying with NQL
Filtering and Transforming Data
Joining Datasets
Creating Materialized Views
Incremental Upserts with MERGE ON
Using Query Templates
Query Optimization
Query Optimization
Avoid OR in JOIN Clauses
Troubleshooting
Data Collaboration
Using Narrative ID
Data Activation
Structuring Audiences for Activation
Connectors
Meta
Compliance
Managing Data Subject Requests
Rosetta Stone
Creating Normalized Attributes
Mapping Schemas
Validating Mappings
Handling Edge Cases
Managing Mapping Evaluations
Accepting AI Mapping Suggestions
Account Settings
API Keys
SSO Configuration
Workflows
Automating Multi-Step Pipelines
Webhooks
Subscribing to Notifications
Tools
Secret Sharing
SDKs
SDK Guides
SDK Authentication
Executing NQL Queries
Managing Datasets
Uploading Data
Running Model Inference
Using Structured Output
Choosing the Right Model
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
Was this page helpful?
Yes
No
Using Query Templates
Avoid OR in JOIN Clauses
⌘I
Assistant
Responses are generated using AI and may contain mistakes.
Contact support