Archives of the TeradataForum
Message Posted: Thu, 20 Jan 2005 @ 11:52:54 GMT
| Subj: || || Re: Insert into empty table with statistics |
| From: || || Victor Sokovin |
| ||The fast-path insert choice is made by each individual AMP at the start of the Merge step. You will not see anything in the explain which
says whether or not the fast-path was chosen. The only way I know to tell is by seeing how fast it runs !|| |
My recollections of this situation date back to V2R4. On that release, I thought it was better to have no statistics at all rather than
the outdated ones. I'm talking, of course, about this particular case. Didn't have a chance to test it on R5.