Archives of the TeradataForum
Message Posted: Thu, 05 Jan 2006 @ 16:49:24 GMT
| Subj: | | Re: Different Explain plan for different users - SAME SQL |
| |
| From: | | Neville Disilva |
Hi Al
I was trying to look for stats while reading your email. Make sure you have current stats. Compare two explains and see the rows sizes in
explains. That's a good place to start. Also if you are on V2R5.0 that might me a bug where optimizer choose wrong table to redistribute, It was
recommended to upgrade to R5.1 as a solution.
Best Regards
Neville DSilva
Teradata Certified Master
| 
