Re: External table performance

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 12 Jan 2018 20:09:46 -0700
Message-Id: <20180112200946.ce5427f0a72eab498fc5ba68_at_gmail.com>


On Fri, 12 Jan 2018 19:23:40 +0000 (UTC) "Sanjay Mishra" <dmarc-noreply_at_freelists.org> (Redacted sender "smishra_97" for DMARC) wrote:

> 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

That's easy: use SSD to house flat files. That would make the performance of the external table much faster.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 13 2018 - 04:09:46 CET

Original text of this message