# Predicate Pushdown
**URL:** https://community.dremio.com/t/predicate-pushdown/3776
**Category:** Uncategorized
**Created:** [July 29, 2019, 2:57pm UTC](https://community.dremio.com/t/predicate-pushdown/3776 "2019-07-29T14:57:41Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Rahul](https://community.dremio.com/u/Rahul)
#### Post date: [July 29, 2019, 2:57pm UTC](https://community.dremio.com/t/predicate-pushdown/3776/1 "2019-07-29T14:57:41Z")
Dear Team
I am using latest dremio 3.2 version. I connected to two mysql databases which are in different servers. When i am executing the join query between tables in these to databases it is doing a full table scan. The ‘where’ condition which i am giving is not getting executed in db side it’s acting as filter while processing.
In my case there is large data on these tables so full table scan won’t be good. Please assist on this.
Thanks & Regards
Rahul
---
### Author:  [@ben](https://community.dremio.com/u/ben)
#### Post date: [July 29, 2019, 4:52pm UTC](https://community.dremio.com/t/predicate-pushdown/3776/2 "2019-07-29T16:52:40Z")
@Rahul,
Can you 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.
---
### Author:  [@Rahul](https://community.dremio.com/u/Rahul)
#### Post date: [July 30, 2019, 6:40am UTC](https://community.dremio.com/t/predicate-pushdown/3776/3 "2019-07-30T06:40:31Z")
Dear Ben
Please find the attached job profile
[666c9d79-1044-43cb-b152-1314dac0d591.zip](https://community.dremio.com/uploads/short-url/rjS2EEFP0hP6762Cv8R8Baiclhr.zip) (7.5 KB)
---
### Author:  [@Rahul](https://community.dremio.com/u/Rahul)
#### Post date: [August 6, 2019, 10:06am UTC](https://community.dremio.com/t/predicate-pushdown/3776/4 "2019-08-06T10:06:10Z")
Dear Ben
After checking the job profile did you got any clue regarding this?
---
### Author:  [@ben](https://community.dremio.com/u/ben)
#### Post date: [August 21, 2019, 5:28pm UTC](https://community.dremio.com/t/predicate-pushdown/3776/5 "2019-08-21T17:28:16Z")
Hi @Rahul,
Apologies for the delay.
You can try a couple of things:
1. Don’t use the VDS @admin.student and @admin.student, but rather reference the queries defining those VDS directly in the join (as subqueries)
2. Dremio should push the down the filter past the join, so this is unexpected. Please rerun the original query with verbose profile logging. To enable verbose profile logging, go to Admin -\> Support -\> scroll down to Support Keys and add `planner.verbose_profile`