# Query Plan Analysis in Dremio

**URL:** https://community.dremio.com/t/query-plan-analysis-in-dremio/12194
**Category:** Uncategorized
**Created:** [August 21, 2024, 7:18am UTC](https://community.dremio.com/t/query-plan-analysis-in-dremio/12194 "2024-08-21T07:18:32Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![AjayBabuM](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@AjayBabuM](https://community.dremio.com/u/AjayBabuM)
#### Post date: [August 21, 2024, 7:18am UTC](https://community.dremio.com/t/query-plan-analysis-in-dremio/12194/1 "2024-08-21T07:18:32Z")

</div>

Hello Team,

I am currently using Dremio version 25.0.5 with MySQL 5.7.32, and I have observed an behavior while executing queries.

When running the following query:

SELECT `Cust_Sub_Id`, `Event_Date`  
FROM `Voice_Seg_Fct`  
WHERE `Event_Date` = ‘2024-04-11’;

I noticed that the query plan displayed by Dremio is as follows:

SELECT `Cust_Sub_Id`  
FROM (SELECT `Cust_Sub_Id`, `Event_Date`  
FROM `Voice_Seg_Fct`) AS `Voice_Seg_Fct`  
WHERE `Event_Date` = ‘2024-04-11’;

I have a couple of observations and questions regarding this:

1. Is it possible to avoid the creation of the derived table as shown in the Dremio query plan?

2. Could the use of derived tables impact memory usage or performance?

I would appreciate any insights or recommendations you might have on these observations.

Thank you for your assistance.

Best regards,  
Ajay Babu Maguluri.

---

<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 21, 2024, 7:00pm UTC](https://community.dremio.com/t/query-plan-analysis-in-dremio/12194/2 "2024-08-21T19:00:12Z")

</div>

@AjayBabuM Seems like the ARP pushdown to MySQL is that. Are you able to share the query profile?

---

<div class="post-metadata">

### Author: ![AjayBabuM](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@AjayBabuM](https://community.dremio.com/u/AjayBabuM)
#### Post date: [August 22, 2024, 10:55am UTC](https://community.dremio.com/t/query-plan-analysis-in-dremio/12194/3 "2024-08-22T10:55:55Z")

</div>

Hi @balaji.ramaswamy

Thanks for quick reply, Please find the query profile.  
[f8b64965-2480-4e59-8ac3-b5c54aa89bc4.zip](https://community.dremio.com/uploads/short-url/rhcOB6ShOjjIEXnwIzgn1LdMKBQ.zip) (18.7 KB)

Best regards,  
Ajay Babu Maguluri.

---

<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 26, 2024, 6:06am UTC](https://community.dremio.com/t/query-plan-analysis-in-dremio/12194/4 "2024-08-26T06:06:13Z")

</div>

@AjayBabuM

The query you have issued on Dremio is

```auto
SELECT "Cust_Sub_Id" FROM MySQL69.EDA.Voice_Seg_Fct WHERE "Event_Date" = '2024-04-11'

```

That is been pushed down to MySQL as

```auto
SELECT `Cust_Sub_Id`
FROM (SELECT `Voice_Seg_Fct`.`Cust_Sub_Id`, `Voice_Seg_Fct`.`Event_Date`
FROM `EDA`.`Voice_Seg_Fct`) AS `Voice_Seg_Fct`
WHERE `Event_Date` = '2024-04-11'

```

Only the column Cust\_Sub\_Id is projected and Filter is also pushed down. It looks like the query is running super fast.