Does type of table [SET/MULTISET] is considered while fetching data from table ?
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 ?