Home
Introduction
The 1010data Macro Language is the most powerful and direct way to interact with 1010data's platform.
Query optimization
Often there is more than one solution to a single problem, and depending on the problem and the data, different approaches can produce better performance. It is important to understand what impacts query performance and how to translate that into optimizing your own queries.

Introduction
The 1010data Macro Language is the most powerful and direct way to interact with 1010data's platform.
- What is in a recipe?
  Each recipe in this Cookbook, with the exception of the Debugging Guide, contains the same basic elements. This page describes the contents of each section contained in a recipe and the elements that make a Debugging Recipe different.
- Difficulty criteria
  Each recipe is equipped with a difficulty measure based on the criteria discussed in this section. A recipe holding a specific difficulty rating can contain one more of the elements in the description of that level or a lower level.
- Query optimization
  Often there is more than one solution to a single problem, and depending on the problem and the data, different approaches can produce better performance. It is important to understand what impacts query performance and how to translate that into optimizing your own queries.
  - Lazy evaluation
    Certain operations in 1010data are not evaluated until the data from those operations are needed by another part of the query.
  - Selections
    The order in which selections are made and the method in which selections are made can affect the efficiency of your query.
  - Links
    You can use <link> operations in 1010data to combine and filter data between tables. However, depending on the type of link and size of your data, this operation can be costly. It is important to know what steps can be taken while using <link> to optimize your query performance.

Query optimization

Often there is more than one solution to a single problem, and depending on the problem and the data, different approaches can produce better performance. It is important to understand what impacts query performance and how to translate that into optimizing your own queries.