We have 2 tables, one table only has 6 rows, and the other one has million rows. We would like to join these 2 tables.
Here is our sql
SELECT * ORACLE_TABLE
INNER JOIN MSSQL_TABLE ON MSSQL_TABLE.car_model = ORACLE_TABLE.car_model
Note: MSSQL_TABLE( only has 6 rows), ORACLE_TABLE( has million rows)
We saw Dremio pulls the whole rows from those tables, and then do the join. The joined result is correct, but I just wonder if there is a way to hint Dremio to select the small table first(MSSQL_TABLE), and then push down the result to the larger table(ORACLE_TABLE) ? This can avoid pulling the whole table data to Dremio.