Sanjay, you did not identify your Oracle version and edition nor post the
actual code you have an issue with but consider the following.
I do not have access to a server where I can test right now but I believe that
you can select from an external table using parallel query if you are on EE.
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
Sent: Friday, January 12, 2018 2:23:40 PM
To: Oracle-L Freelists
Subject: External table performance
Can someone share the Tuning activites that can be done for Selecting data from
External table in 12c (12.1)? I am working on project that is getting every
6hourly data as flat file from external source and then has to be selected from
ORacle table for some processing. Data is only 50K records but Select is taking
time. It is Local Storage where File is located. I don;t think we can have
indexes yet and so checking experience from the experts.