External table performance
From: Sanjay Mishra <"Sanjay>
Date: Fri, 12 Jan 2018 19:23:40 +0000 (UTC)
Message-ID: <897591886.2094773.1515785020866_at_mail.yahoo.com>
Date: Fri, 12 Jan 2018 19:23:40 +0000 (UTC)
Message-ID: <897591886.2094773.1515785020866_at_mail.yahoo.com>
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. TxSanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 12 2018 - 20:23:40 CET