(adding more) The issue described on stack overflow is also very likely if you have a complex schema.
On Mon, Apr 19, 2021 at 8:40 AM Ted Dunning <[email protected]> wrote: > > > 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 >> >>
