Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 14 Feb 2004 @ 15:21:51 GMT

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

Subj:   Re: Different explains from queryman versus Session Information in Teradata Manager
From:   Thomas F. Stanek


I am guessing that you are on V2R4.x. There is a DBSControl setting that will allow you to see the actual table and database names in the explain text from Session Info. It's field #24 in the General Fields section. It is called EnableStepText. Set it to TRUE and you will then see the actual database and table name references instead of the internal object IDs. In V2R5, this parameter has been removed. The object names are always shown.

I am guessing that the query is working the same, but the abbreviated explain from Session Information, combined with the fact that you are not seeing the actual object name, might be misleading you. I am guessing that the object id specified in step #5 is actually the Index #8 sub-table. I say that because step #5 for both explains is doing a all-rows scan on an object and doing a nested join to the spool from the previous step. Furhtermore, all of the other steps appear to be the same as well.

I hope this helps answer your question.


Thomas F. Stanek
APP Consulting, Inc. (Formerly TFS Consulting, Inc.)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016