Oracle view query performance issue

datatable

#1

Hi there,

I am using database execute query activity to connect oracle database and run a simple query .e.g select * from ‘an oracle view’ where column in (value list);

per my testing it costed 50 minuts to return 121097 records while it costed only 5 minutes in oracle sql developer (I run the same query and export data manually into excel file).

so I simply have a conclusion that UiPath has 10 times worse performance than Sql developer does.
does anybody have same experience on database query and any suggestions to tune?