0 - 2 of 2 tags for different explain
all-AMPs MERGE into from Spool N (Last Use) - Huge Estimation Difference

Apologies if  might have already been answered in this forum, but my 5 minute search did not get me anywhere. Hence a new thread.
Running SQLA 14.01 on TD14
Issue:

By nomadic_being, 19 Sep 2014 | Tagged: explain plan different explain teradata explain INSERT INTO join performance | 2 comments
Explain plans differ when object (view) names are fully qualified and when they are not

Does the optimizer treat a query differently when the object names in the query are fully qualified vs. when they are not fully qualified ?
I came across a query which gives one explain plan when the views referenced by the query are fully qualified i.e. <databasename>.<viewname>

By amit.s, 01 Nov 2012 | Tagged: explain plan query performance fully qualified object names table names view names different explain | 4 comments