fastexport/multiload vs. insert/select

[saxgeek]

Does doing a fastexport/multiload into an empty table perform faster than an insert/select into an empty table?

 

[RogerCruse]

I'm guessing the answer will be the same. Its going to depend more on which utility you want to use - BTEQ, FASTEXPORT, MULITLOAD - and why.

Why don't you simply run a test with your data and compare the results.


Roger...

 

[dnoeth]

Insert/Select into an empty table usually is the fastest way, just search the manuals for "fast path optimization" about restrictions.

Dieter

 

[tjs4145]

A bteq will will only be faster if the desired data exists on existing tables (it will be significantly slower if an error is encountered mid-process).

A bteq will go row by row, a fastload can go by blocks. If you have a large file (relative to your system) you want to load it via fastload. If you have a small file (<65k at my site) use bteq.

Fastload only makes sense if you actually have a file that you need loaded (versus a table created whose data is comprised of existing information).

 

[jl162401]

Fastload is the fastest way if you load data in an empty table, Select/Insert is also a faster way,
bteq can not compared with select/insert, they are different level, SQL can run in betq, select/insert is a SQL.