Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 18 Oct 2000 @ 14:11:24 GMT

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

Subj:   Re: Star Schema
From:   Alan Friel

Steve Bracewell wrote:

  There are a couple of methods we use. One is an old tried and true NCR solution, not pretty, but effective. By adding a meaningless column to the dimension tables and using syntax like below, you can 'force' the product join of the smaller tables.  

  AND (T.Meaningless_column = P.meaningless_column
OR T.meaningless_column <> P.meaningless_column)
AND (T.meaningless_column = G.meaningless_column
OR T.Meaningless_column <> G.Meaningless_column)

That is really old fashion and orginiated about Teradata Version 2 (probably about the late 1980's). The parser and optimizer have made real improvements since that time and using such a trick should be unnecessary.

In the best case it doesn't do anything better than what the parser would do on its own. In the worst case, doesn't it prevent the parser and optimizer from developing the best work plan? I guess it would be OK if you had a very narrow range of handcrafted queries, but if we're going to open our databases to our users, shouldn't we expect more flexibility and that the parser should be able to create a good plan without resorting to tricks?

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023