 |
 |
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
| |
