Archives of the TeradataForum
Message Posted: Mon, 24 Mar 2003 @ 20:59:38 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|