Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the diffrence between Multiload & Fastload interms
of Performance?

Answer Posted / yuvaevergreen

In terms of speed, fastload would be suitable than mload for
loading an empty table.
But when it comes to multiset tables, mload would be a
better option.
Mload allows use of aggregated values whereas fastload does not.

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the command in bteq to check for session settings ?

1115


how can we analyze the locks ?

2058


What is inner join and outer join?

1037


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

979


What are the different functions performed in development phase?

1013


Can we collect statistics on table level?

987


What are some commonly used bteq scripts?

942


How many sessions of MAX is PE capable of handling at a particular time?

1031


What is oltp?

914


What is teradata? Also, list out some of the primary characteristics of teradata.

979


Explain teradata vs. Redshift?

955


Name the five phases that come under MultiLoad Utility.

928


What do you mean by fastexport in teradata?

939


why use references rather than pointers in the public api, particularly for arguments which are modified?

937


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1152