Archives of the TeradataForum

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

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

Michael,

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.

Regards,

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

WWW.TFSCONSULTING.COM

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