Archives of the TeradataForum

Message Posted: Tue, 24 Oct 2006 @ 20:29:20 GMT


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

Subj:		Re: Execution of multiple macro's inside a macro

From:		Dieter Noeth

Amit Kumar Sinha wrote:

I want to find out when we have multiple macro's inside a macro then these macro's are processed parallel or sequentially? I went through the explain plan also but nowhere I got the hint that these macro's are processed in parallel.

What are you doing within those nested macros?

The source code of all macros is resolved and looks like a single multistatement to the optimizer.

If the optimizer recognizes independent accesses to different tables, it could do it in parallel.

     > REPLACE MACRO LOAD_TEST_MACRO(
     > in_test CHAR(5)
     > )
     >
     > AS
     > (
     > EXEC  LOAD1(:in_test);
     > EXEC  LOAD2(:in_test);
     > EXEC  LOAD3(:in_test);
     > EXEC  LOAD4(:in_test);
     > EXEC  LOAD5(:in_test);
     > EXEC  LOAD6(:in_test);
     > );

Could you show the source codes?

Dieter