Archives of the TeradataForum
Message Posted: Thu, 09 Nov 2006 @ 18:40:25 GMT
| Subj: | | Re: Value Ordered NUSI & Regular NUSI on Same Column? |
| |
| From: | | Dieter Noeth |
Suwandi Teow wrote:
| | The thing is if we have an ordered by value column, an equality where clause statement will not use the index. The index is only used when
we modified the sql statement slightly to use between condition. | |
Is that date outside of the statistis range?
Although in that case case i'd expect the optimizer to use the index with equality and not with between.
Check explain for confidence level and estimated number of rows.
If those are ok, this looks like a bug to me...
Dieter
| 
