# What is a Dremio reflection?

What is a Dremio reflection?

##### Post Metadata
- Posted at: over 3 years ago
- Author title: Pinned by G2 as a common question



## Comments
### Comment 1

A reflection is an optimized materialization of source data or a query, similar to a materialized view, that is derived from an existing table or view. A table or view that a reflection is derived from is that refection’s anchor.

Dremio’s query optimizer can accelerate a query against tables or views by using one or more reflections to partially or entirely satisfy that query, rather than processing the raw data in the underlying data source. Queries do not need to reference reflections directly. Instead, Dremio rewrites queries on the fly to use the reflections that satisfy them.

You can read more here: https://docs.dremio.com/cloud/reflections/

##### Comment Metadata
- Posted at: over 3 years ago
- Author title: Corporate Communications @ Dremio




## Related Product
[Dremio](https://www.g2.com/products/dremio/reviews)

## Related Category
[Big Data Processing and Distribution](https://www.g2.com/categories/big-data-processing-and-distribution)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4