• Register
  • Log in
  • Community
  • Downloads
  • Forums
  • Blogs

Search form

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
Contact Us | Privacy Policy | Terms of Use | Tracking Consent | Send Feedback | Teradata.com
Copyright © 2004-2015 Teradata Corporation. Your use of this Teradata website is governed by the Privacy Policy and the Terms of Use, including your
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.
The Privacy Policy and Terms of Use for this Teradata website changed effective April 13, 2015.