Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2006 @ 11:19:21 GMT

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

Hi David,

Strangely, we are experiencing a different things here. We are on V2R5.1.2 at the moment. So it might be different with your case.

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.

For example

This where clause will not use value ordered index :

     Where date_column = date'2006-10-01'

In contrast this where clause will use value ordered index :

     Where date_column between date'2006-10-01' and date'2006-10-01'

Back to the main topic, I think value ordered index will be enough for both purposes, but sqls with equality condition need to be modified to use between criteria to make use of value ordered index.

Regards,

Suwandi Teow
Globalsoft Australia

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