Re: Query with contents of text file.

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 24 Apr 2006 13:32:36 -0700
Message-ID: <1145910756.352632.305420@v46g2000cwv.googlegroups.com>

The disadvantage of the external table is that you can not create an index on the data. If the external table is or can be used as the driving table in a process this is usually not a requirement, but if you need to join to the external table driving from a regular table then an index might be necessary for performance. In that case you would probably want to load the data into a real table.

Another disadvantabe an external table is not backed up as part of the db.

HTH -- Mark D Powell -- Received on Mon Apr 24 2006 - 15:32:36 CDT