> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Query Engine

> DuneSQL, a Trino fork, is fine-tuned for blockchain analytics.

<Tip>
  New to DuneSQL? Watch our [DuneSQL overview video](/resources/learning/video-tutorials#dunesql-overview) for a quick introduction.
</Tip>

DuneSQL enhances blockchain data analysis by leveraging a Trino fork. This engine excels in performance for interactive queries across vast datasets, from gigabytes to petabytes.

## Key Features

DuneSQL shines with unique blockchain-focused capabilities:

* **Varbinary Data Types**: Store blockchain specifics like addresses and hashes efficiently.
* **Uint256 & Int256 Support**: Essential for blockchain's large numerical data.
* **Columnar Storage**: Optimizes read speed by organizing data by columns.
* **Query Views**: Enables complex query construction and reusability.
* **Materialized Views**: For enhanced query performance through pre-computed results.

## DuneSQL Essentials

DuneSQL offers a robust platform for blockchain data exploration. As a modified version of TrinoSQL, it supports scalable, interactive analysis across diverse data sizes.

Our documentation equips you with the necessary tools to efficiently harness DuneSQL.

<CardGroup cols={3}>
  <Card title="Functions and Operators" icon="screwdriver-wrench" iconType="duotone" href="/query-engine/Functions-and-operators/">
    DuneSQL's syntax toolbox.
  </Card>

  <Card title="Data Types" icon="clipboard-list" iconType="duotone" href="/query-engine/datatypes">
    Understanding DuneSQL data formats.
  </Card>

  <Card title="Reserved Keywords" icon="book-open" iconType="duotone" href="/query-engine/reserved-keywords">
    Keywords off-limits for naming.
  </Card>

  <Card title="Writing Efficient Queries" icon="rocket" iconType="duotone" href="/query-engine/writing-efficient-queries">
    Strategies for query optimization.
  </Card>

  <Card title="Querying a Query" icon="circle-nodes" iconType="duotone" href="/query-engine/query-a-query">
    Layer queries for complex insights.
  </Card>

  <Card title="Materialized Views" icon="database" iconType="duotone" href="/query-engine/materialized-views">
    Boost query speed with stored views.
  </Card>
</CardGroup>

## Debugging

Need help with DuneSQL? Start here:

* Google `<problem> Trino SQL` for general inquiries.
* Chat with your favorite AI assistant and ask for `Trino SQL` help.
* Check [Trino's official documentation](https://trino.io/docs/current/functions.html) for detailed insights.