Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Feb 2012 @ 16:29:53 GMT


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


Subj:   Re: How to clear the Orphan Access rights
 
From:   Pluebell, Fred

If you drop a table on which no privileges have been explicitly granted, Teradata uses PI access and RowHash locks to delete rows corresponding to the automatic rights (inserted as part of the CREATE TABLE), rather than acquiring a table write lock on access rights and scanning the table to delete any matching rights.

This is a major performance optimization for the log / error / work tables created by Teradata Utilities, for example. But as in the scenario Geeta describes, it may rarely cause some "orphan" rows to be left behind. It's not a problem as long as the number of orphan rows remains very small compared to the total size of AccessRights.



     
  <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