Archives of the TeradataForum

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

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

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>>