Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Oct 2002 @ 14:28:12 GMT


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


Subj:   Re: Multiple Views of an Object and the Optimizer
 
From:   Frank C. Martinez IV

Nope, I don't. Views are just source, just like running separate queries. The optimizer might say something in the explain like the base table would be eligible for synchronous scanning (what the heck is that term anyway?), but it has no idea WHEN you're going to run queries with this source. And if you're using unique subsets of columns, what would it use for the index to the spool? The index has to be one of the columns after all, and if they're exclusive to each view, then, hey, what's it going to use? Perhaps more clarification would allow us to assist.

iv



     
  <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: 23 Jun 2019