Does type of table [SET/MULTISET] is considered while fetching data from table ?

General
Enthusiast

Does type of table [SET/MULTISET] is considered while fetching data from table ?

Hi,

As per my understanding, if I am sure that SOURCE will always send UNIQUE rows I should create Target table as MULTISET table as it will ignore the ROW LEVEL CHECK which a SET table performs to check for duplicate rows. So loading of data will be much faster in MULTISET table than SET table. Am I correct ?

Now at the time of retreiving the data from table , it only depends on INDEX column and index type and not on SET/MULTISET table ? We know while loading table, SET/MULTISET matters however does it matter even while retreiving data from table ?