All Forums Tools
smarty 14 posts Joined 03/09
17 Mar 2009
Mload Vs Fastload

Hi,Which utility is faster Mload or Fastload if we are loading data into an empty table and why?Can we load duplicates into a multiset table with a NUPI using Mload?Thank You

sRavanSarma 23 posts Joined 11/08
17 Mar 2009

Hi,For loading data into a empty table, FastLoad is the efficient one.

Jim Chapman 449 posts Joined 09/04
17 Mar 2009

FastLoad is generally faster when loading an empty table because FastLoad was designed specifically for that purpose. FastLoad can sort the incoming rows directly into the target table, whereas MultiLoad first sorts the incoming rows into a worktable and then applies the worktable to the target table.MultiLoad fully supports mulltiset tables with duplicate rows.

teramurali 21 posts Joined 11/08
23 Mar 2009

hi, Having empty table, fload is best bcz of in fload we have 2 phase only but mload 5 phases......so performance wise fload is best......for empty tables only...we can load duplicate data into multiset in mload

You must sign in to leave a comment.