Presentation Information

Presentation Title:   External tables - what are they, and why you should use them
Primary Speaker:   Mike Walker
Informix External Tables - you've probably heard of them, but have you used them?

External tables allow the reading from, and writing to filesystem files through SQL. They offer more flexibility in unloading and loading data than regular unload/load statements, and are much easier to use than the High Performance Loader. On top of this, they provide significant performance advantages over many other methods of moving data.

Mike will show how to use external tables and describe how they can be used for:

ETL processing
Table reorgs/alters

Benchmarking comparisons of different unload/load methods will be shared, and Mike will also show a demo of using external tables.
or Panelists: