Archives of the TeradataForum
Message Posted: Tue, 16 May 2006 @ 17:32:43 GMT
| Subj: || || Re: PPI Explain Plan |
| From: || || Victor Sokovin |
| ||I was expecting both the explain plan similar.|| |
Why? "Estimated with no confidence", which shows up in the second explain plan, suggests that (relevant) stats have probably not been
collected. If that is true, try to collect them. Perhaps that will help bring the plans closer to each other. I trust you have a good reason to
believe they should be similar; I for one would not bet on that.