Archives of the TeradataForum

Message Posted: Fri, 27 Sep 2002 @ 11:50:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Mike,

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.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>