# Serve results

Serving results from Materialize




> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


In Materialize, indexed views and materialized views maintain up-to-date query
results. This allows Materialize to serve fresh query results with low latency.

To serve results, you can:

- [Query using `SELECT` and `SUBSCRIBE`
  statements](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/query-results/index.md)

- [Understand the query lifecycle](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/query-lifecycle/index.md)

- [Use BI/data collaboration tools](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/index.md)

- [Sink results to external systems](https://preview.materialize.com/materialize/40269/markdown-docs/export-data/index.md)

- [Use Foreign Data Wrapper (FDW)](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/fdw/index.md)

<div class="multilinkbox">
<div class="linkbox ">
  <div class="title">
    SELECT/SUBSCRIBE statements
  </div>
  <ul>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/query-results/index.md" >Query using <code>SELECT</code> and <code>SUBSCRIBE</code></a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/query-lifecycle/index.md" >Query lifecycle</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/fdw/index.md" >Use Foreign Data Wrapper (FDW)</a></li>
</ul>

</div>

<div class="linkbox ">
  <div class="title">
    External BI tools
  </div>
  <ul>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/deepnote/index.md" >Deepnote</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/excel/index.md" >Excel</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/hex/index.md" >Hex</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/metabase/index.md" >Metabase</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/power-bi/index.md" >Power BI</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/tableau/index.md" >Tableau</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/looker/index.md" >Looker</a></li>
</ul>

</div>


<div class="linkbox ">
  <div class="title">
    Sink results
  </div>
  <ul>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/export-data/s3/index.md" >Sinking results to Amazon S3</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/export-data/census/index.md" >Sinking results to Census</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/export-data/kafka/index.md" >Sinking results to Kafka</a></li>
<li><a href="https://preview.materialize.com/materialize/40269/markdown-docs/export-data/snowflake/index.md" >Sinking results to Snowflake</a></li>
</ul>

</div>


</div>



## Pages in this section

- [`SELECT` and `SUBSCRIBE`](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/query-results/index.md): Querying results from Materialize using `SELECT` and `SUBSCRIBE`.
- [ADBC (Arrow Database Connectivity)](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/adbc/index.md): Use the ADBC PostgreSQL driver to pull Materialize results into Apache Arrow
- [Client libraries](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/client-libraries/index.md): Connect via client libraries/SQL drivers
- [Connect to Materialize via HTTP](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/http-api/index.md): How to use Materialize via HTTP
- [Connect to Materialize via WebSocket](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/websocket-api/index.md): How to use Materialize via WebSocket
- [Connection Pooling](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/connection-pooling/index.md): How to use connection pooling with Materialize
- [Durable subscriptions](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/durable-subscriptions/index.md): How to enable lossless, durable subscriptions to your changing results in Materialize
- [Foreign data wrapper (FDW) ](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/fdw-setup/index.md): Use FDW to access Materialize
- [Isolation levels](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/isolation-level/index.md): Materialize supports different isolation levels that determine how it isolates the execution of transactions.
- [SQL clients](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/sql-clients/index.md): How to connect to Materialize using common SQL clients
- [Troubleshooting](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/troubleshooting/index.md): Troubleshooting guides for queries that are slow, unresponsive, or expensive in Materialize.
- [Understand the query lifecycle](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/query-lifecycle/index.md): Understand how Materialize executes a `SELECT` query, and what latency to expect for each type of query.
- [Use BI/data collaboration tools](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/bi-tools/index.md): Querying results from Materialize using external BI/data collaboration tools
- [Use foreign data wrapper (FDW)](https://preview.materialize.com/materialize/40269/markdown-docs/serve-results/fdw/index.md): Use FDW to query results from Materialize