I have a table say "Test" in which I am outer joining few tables. After that there is another table in which I am using fields from table Test, something like this:
and so on. After this I am creating another table using fields from Test
group by ...;
Now the problem is that after Test table has been loaded, It takes a lot of time to load table Test1.
When I checked in log file i found that after Test is loaded, there is a statment Joining/Keeping and then Test1 starts loading. However, I do not want this table Test1 to be joined to anything. I tried using Noconcatenate also, but i am not able to make it work.