Archives of the TeradataForum

Message Posted: Tue, 25 Mar 2003 @ 17:46:57 GMT


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

Subj:		Re: Teradata sql and range value queries

From:		Dieter N�th

Raj Basu wrote:

Great feedback....I am going to try the value ordered index thing. We are not in v2r5 yet, so partitioned index is not an option. I haven't yet tried the correlated subquery yet but will try it today. I hope that dosen't do a "query rewrite as well" :)!

Sorry to dissapoint you, but a correlated subqeury is rewritten as join also...

Dieter