Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 31 Jan 2003 @ 12:23:31 GMT

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

Subj:   Re: Query optimization: difference between inner join and derived table?
From:   Doorey, Andrew ST

Have you tried to run it using a where clause to join the tables instead of the inner join?

When we first set up Microstrategy we found this more efficient, especially if there are other elements in the where clause, as it then filters out only the rows from table2 it needs before joining the tables. This doesn't seem to make a difference since we upgraded to a more recent version though.

You can set the join type in the Microstrategy VLDB properties. Choose 'SQL89 Inner Join and SQL92 Outer Join and Cross Join'

Also, if table2 isn't a unique list of rid's then you should build a table or view that is a unique list, map that into Microstrategy and set it as the lookup table. Microstrategy assumes that all attributes have a lookup table with unique values.

  <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: 28 Jun 2020