# VDS is scanning all the available reflections

**URL:** <https://community.dremio.com/t/vds-is-scanning-all-the-available-reflections/7835>\
**Category:** Dremio University\
**Created:** [August 6, 2021, 6:20pm UTC](https://community.dremio.com/t/vds-is-scanning-all-the-available-reflections/7835 "2021-08-06T18:20:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![KS295](https://avatars.discourse-cdn.com/v4/letter/k/779978/32.png) [@KS295](https://community.dremio.com/u/KS295)\
**Post date:** [August 6, 2021, 6:20pm UTC](https://community.dremio.com/t/vds-is-scanning-all-the-available-reflections/7835/1 "2021-08-06T18:20:30Z")

</div>

Hi ,

I have created a VDS with reflection.  
while running a select on VDS its scanning all the available reflections and then using the suitable reflection for accelerating the query.  
This scanning is causing the slowness to query as there are many reflections is available is system.

Can you please suggest a way where we can point to a single reflection and avoid scanning all the reflections?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [August 7, 2021, 2:29am UTC](https://community.dremio.com/t/vds-is-scanning-all-the-available-reflections/7835/2 "2021-08-07T02:29:55Z")

</div>

@KS295 Starting Dremio 4.8, default reflections should help address this, for a reflection to be qualified as a default reflection it needs to be

- On a VDS
- A raw reflection
- All columns of the VDS has to be selected
- The job should be a query

Is the reflection that is getting used a raw or an agg reflection? Also how many columns are there? Can we also get a profile where there are many reflections considered

---

<div class="post-metadata">

**Author:** ![KS295](https://avatars.discourse-cdn.com/v4/letter/k/779978/32.png) [@KS295](https://community.dremio.com/u/KS295)\
**Post date:** [August 7, 2021, 5:42am UTC](https://community.dremio.com/t/vds-is-scanning-all-the-available-reflections/7835/3 "2021-08-07T05:42:21Z")

</div>

Hi Balaji,

Thank you for the quick response.

- Yes reflection is on a VDS
- Yes its a Raw reflection
- Yes its using all the columns
- Yes The job is a query.

not sure either its scanning reflection under the same folder or entire system.  
Query is not running due to this.

regards,

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [August 7, 2021, 5:26pm UTC](https://community.dremio.com/t/vds-is-scanning-all-the-available-reflections/7835/4 "2021-08-07T17:26:57Z")

</div>

@KS295

Can you please share the job profile?

> **[How To Share A Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)**
>
> Tutorial explaining how to share a query profile in Dremio.