 |
 |
Archives of the TeradataForum
Message Posted: Fri, 10 Nov 2006 @ 21:43:48 GMT
| Subj: | | Re: Value Ordered NUSI & Regular NUSI on Same Column? |
| |
| From: | | Victor Sokovin |
| | 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, such cases are reported regularly and whether they are bugs or not they need to be addressed. Changing the syntax to BETWEEN is not
always a solution as some SQL statements may be generated by third-party utilities. If having a hash-ordered index helps address this issue then
this is already a valid reason to have this type of index next to the value-ordered index. Of course, this is expensive but if performance is a
priority then why not use all means?
Regards,
Victor
| |
