Archives of the TeradataForum
Message Posted: Fri, 27 Sep 2002 @ 11:50:21 GMT
Has the NUSI column got skewed data values? I've seen the optimizer switch between index access and full table scan (understandably) in this circumstance.
If your NUSI column is numeric, have you tried a value-ordered NUSI?
If these don't help you then send me the word doc and I'll have a look.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|