Archives of the TeradataForum

Message Posted: Mon, 24 Mar 2003 @ 20:59:38 GMT

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

Hi ,

we are starting to implement a Teradata datawarehosue here and have run into a few issues with the sql.

1) there seems to be no index support for range value queries. Like, x>10 and x<15 or x between 10 and 15. The moment you use >< operator , you loose the index. I guess the hash indexing schema is unable to support this, while a b-tree index would have been able to. Have any of you been able to find a workaround for this? or are we destined to full table scans the moment we submit an inequality query.

2) subquery's seem to support the ansi-99 standard syntax, but underneath, just join the the nested and outside tables together on the common column...instead of running the outside query once for each value returned by the subquery query. Is there a workaround for this too?

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