Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 01 Nov 2005 @ 17:12:18 GMT


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


Subj:   Re: OK What Gives???
 
From:   Coffing Christopher

Helloooo!

Evidently the issue is not that the Index is being created as much as the Index is being used.

The SHOW SQL statement returns all of the objects used in the SQL statement from the views to the underlying tables. This includes the dbc.tvm (TVMNAME) index...

The issue that I was running into as a view that was not locking for access where it should have been...

Sorry for the alarm... I can sleep now..


Chris Coffing



     
  <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