What does it even mean that data is not loaded into the table in case of external table? and how does it “read” the data that is not even loaded? I am new to this and want a detailed answer on how these processes work.
Also please mention how can it improve performance with respect to SQL Loader ? please explain in a beginner friendly manner.
I searched the stuff on the Internet but was bit confusing.
Also when can be the cases that it causes performance issues?