Archives of the TeradataForum

Message Posted: Fri, 04 Aug 2006 @ 16:57:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

Could you please explain me the difference between MSR(multi statement request) and the Union.

I want to insert into a table from 3 different queries, should I use MSR or Union (or Union all) to do the job.

Which one will be more efficient?

thanks & regards

Prahlad Patidar

	<Prev	Next>		<<First	<Prev	Next>	Last>>