![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 04 Nov 2003 @ 17:21:33 GMT
Subj: | | Re: No Stats query runs better? |
|
From: | | Fenwick, Ruth |
James,
I've seen it before, and it's always been an optimizer bug....I know there are those who believe that it's an acceptable 'tuning' method
to drop statistics, but I maintain that it's ALWAYS a bug if giving the optimizer more, correct information results in a poorer access
path. (I am assuming that when you say all stats it's a given that they are current).
You don't mention what the table structures are or the SQL to access, but I suspect what's happening is that when there are no stats, the
parser is sampling on AMP and you're getting lucky that it choose the correct access path.
Ruth Fenwick
Database Services
| |