Dileep, As Charles suggested, the problem is probably to do with limitations on what parts of the query is being pushed down into Oracle. That results in lots of data motion that isn't necessary when the query is executed entirely within Oracle because the Oracle database can use indexes and such to avoid even looking at much of the data (and even if it does look, it has much faster channels than JDBC available).
On Mon, Apr 19, 2021 at 5:12 AM Charles Givre <[email protected]> wrote: > Dileep, > You also may want to take a look at this article from SO. > > > https://stackoverflow.com/questions/41814970/extremely-slow-apache-drill-query-using-oracle-jdbc > > -- C > > > > > On Apr 19, 2021, at 5:45 AM, dileep kumar <[email protected]> wrote: > > > > Hi Team, > > > > > > > > I am a novice in Drill and getting my hands dirty on Apache Drill. > > > > I have installed Drill and am trying to execute a query(joins multiple > > oracle tables) against Oracle database. > > > > Same query is executed in 0.34 seconds on the oracle server , but in > Drill > > it took 31 mins which is weird. > > > > I tried increasing Heap memory but still no change in performance. > > > > Can someone there help me out ? > > > > > > > > Regards > > > > Dileep Kumar > >
