[Reposting of the article published with Sitaram Vemulapalli on DZone. https://dzone.com/articles/a-deep-dive-into-couchbase-n1ql-query-optimization] SQL is the declarative language for manipulating data in a relational database system. N1QL is the declarative language for JSON data and metadata. Similar to SQL, N1QL has DML statements to manipulate JSON data: SELECT, INSERT, UPDATE, DELETE, MERGE, EXPLAIN. It also introduces a new statement, INFER , which samples the data to describe the schema and show data samples. Execution of a N1QL query by the engine involves multiple steps. Understanding these will help you to write queries, design for performance, tune query engine efficiently. The N1QL query engine includes parser, semantic analyzer, optimizer and executor. This article will describe how the N1QL query optimizer creates the query plan. Life of a Query: Overview Applications and their drivers submit the N1QL query to one of the available query n...
A blog about all things data and data processing issues and interests. SQL, NoSQL, flexible schema, scale-up, scale-out, transactions, high availability.