Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 12 Jul 2001 @ 14:00:47 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Optimizing query path between large and small tables
From:   Anomy Anom

<-- Anonymously Posted: Thursday, July 12, 2001 09:15 -- >


Thanks for the input, unfortunately there is no NUSI on the large table that joins to the NUPI of the 2 ref. tables. The table was designed this way 2-3 years ago without this join in mind (the ref. tables did not exist). It is only now that the development of new feeds have queried the design of the table on the warehouse.

I have already pointed this out as the best (if not the only) method but the owners are unwilling due to the extra space usage - looks like I'll just have to keep the code as is!

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