Archives of the TeradataForum
Message Posted: Wed, 02 Feb 2005 @ 10:39:41 GMT
| Subj: || || Different Explains for the same query |
| From: || || Rohit Revo |
I am facing a peculiar situation where the SQL when run inside the macro runs in 1 min, but the same query when run as a Macro hangs up.
Basically I am getting a different Explain when I run the SQL inside Queryman (better EXPLAIN) and a different Explain when I put the SQL inside a
macro and run the macro instead.
Any insights into this much appreciated.