Hello everyone, locally on my computer i have dremio installed and i’m connecting to an elasticsearch cluster and an oracle database to be able to make queries about both data sets. When i make a simple query (just retrieve some columns) in Dremio to the elasticsearch cluster, for example an index that has 20 million records, the query takes approximately 4 minutes to complete. On the other hand, when I make a very simple query in Dremio (very similar to the previous one) in my oracle table which has only two million records the query took about an hour and a half to return the results.
What could be the reason that for a set of data it takes so little time but for the other it takes so much time?
What can I do to improve the response time when consulting my Oracle data set? (apart from the reflections)
I appreciate any help you can give me,
Thanks in advance!