|
|
Archives of the TeradataForum
Message Posted: Thu, 05 Aug 2004 @ 21:52:32 GMT
Subj: | | Re: PMON explain window |
|
From: | | Frank C. Martinez IV |
Two small corrections...
1) The PMon explain does have estimates as of TTU 7.1, but not in the explain itself, right next to it on the display of the SQL in
PMon. On the screen, you have the comparison of estimated to actual. Very nice.
2) The actual table names can be displayed under v2r4 by setting a gdo parameter, can't remember which one, which turns off
displaying the table id's and turns on seeing the table names in PMon. I looked through my notes to find the name of the parameter, but couldn't
find it.
iv
PS: As far a spool file numbers, well, they can't actually give them names, you know? I mean, what would they use, like "James" or
"Martha"?
| |