# Relection too expensive?

**URL:** <https://community.dremio.com/t/relection-too-expensive/2809>\
**Category:** Uncategorized\
**Created:** [February 20, 2019, 7:46pm UTC](https://community.dremio.com/t/relection-too-expensive/2809 "2019-02-20T19:46:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![summersmd](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@summersmd](https://community.dremio.com/u/summersmd)\
**Post date:** [February 20, 2019, 7:46pm UTC](https://community.dremio.com/t/relection-too-expensive/2809/1 "2019-02-20T19:46:54Z")

</div>

I have 2 reflections on the same VDS. Ref#1  
is a Raw Reflection (1.81MB) with all columns selected and Ref#2 (390KB) is a Raw Reflection with a subset of the columns selected. We have a query that uses all of the columns in Ref#2 but Ref#1 is selected for that query with Ref#2 being deemed too expensive. Can you explain why this might happen?

---

<div class="post-metadata">

**Author:** ![kelly](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kelly/32/11_2.png) [@kelly](https://community.dremio.com/u/kelly)\
**Post date:** [February 20, 2019, 8:04pm UTC](https://community.dremio.com/t/relection-too-expensive/2809/2 "2019-02-20T20:04:58Z")

</div>

Which version of Dremio?

---

<div class="post-metadata">

**Author:** ![summersmd](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@summersmd](https://community.dremio.com/u/summersmd)\
**Post date:** [February 20, 2019, 10:51pm UTC](https://community.dremio.com/t/relection-too-expensive/2809/3 "2019-02-20T22:51:12Z")

</div>

We running version 3.1.1

---

<div class="post-metadata">

**Author:** ![summersmd](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@summersmd](https://community.dremio.com/u/summersmd)\
**Post date:** [March 7, 2019, 5:06pm UTC](https://community.dremio.com/t/relection-too-expensive/2809/4 "2019-03-07T17:06:30Z")

</div>

Can you explain why this might happen? We’re seeing this behavior more frequently.
