# Is there a way to limit reflections to check

**URL:** <https://community.dremio.com/t/is-there-a-way-to-limit-reflections-to-check/6196>\
**Category:** Uncategorized\
**Created:** [September 2, 2020, 6:46pm UTC](https://community.dremio.com/t/is-there-a-way-to-limit-reflections-to-check/6196 "2020-09-02T18:46:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mlilius](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mlilius/32/5145_2.png) [@mlilius](https://community.dremio.com/u/mlilius)\
**Post date:** [September 2, 2020, 6:46pm UTC](https://community.dremio.com/t/is-there-a-way-to-limit-reflections-to-check/6196/1 "2020-09-02T18:46:21Z")

</div>

I have a VDS that has about 30 reflections (from other VDS) that match and are checked as possible accelerators. I am finding that it is spending more time planning then actually running the query. I suspect that this is because there are so many reflections that match. Is there a way to tell dremio to only consider the reflection(s) that are part of the VDS being queried? Or is there a way to tell dremio to limit the number of reflections to consider?

Thanks  
Matthew

edit: I also get a number of “Failure while attempting substitution, skipping materialization ###” errors

---

<div class="post-metadata">

**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\
**Post date:** [September 3, 2020, 3:52am UTC](https://community.dremio.com/t/is-there-a-way-to-limit-reflections-to-check/6196/2 "2020-09-03T03:52:32Z")

</div>

@mlilius,

Currently there is no way to limit the number of reflections that are considered during query planning. If the reflections have source datasets and include columns that cover you query, then they will be considered. It sounds like maybe there is some redundancy in your reflections. It may be possible to only reflect a select few datasets and do the same jobs with less planning time.

You might find our [white paper on reflections best practices](https://www.dremio.com/lp/data-reflections-best-practices) useful to this end.

As for the errors what does the `sys.materialization` and `sys.reflections` tables say about the materializations that are report the error?

---

<div class="post-metadata">

**Author:** ![mlilius](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mlilius/32/5145_2.png) [@mlilius](https://community.dremio.com/u/mlilius)\
**Post date:** [September 21, 2020, 1:46pm UTC](https://community.dremio.com/t/is-there-a-way-to-limit-reflections-to-check/6196/3 "2020-09-21T13:46:56Z")

</div>

The new default reflection feature in 4.8 looks like exactly what I needed! Thank you.

> **[4.8 Release Notes · Dremio](https://docs.dremio.com/release-notes/48-release-notes.html#default-reflections)**