Archives of the TeradataForum
Message Posted: Wed, 30 Sep 2009 @ 13:06:18 GMT
| Subj: || || Making a case for access rights cleanup |
| From: || || Steve Hager |
Are there overall system performance implications if the access rights are bloated on Teradata? Will the system run better overall if a
significant reduction (say 50%) is made in the number of access rights? Are there any particular types of DDL or DCL operations whose response
times could be measured and would be run faster if such a cleanup was undertaken? Any other suggestions on measurements showing success?
Note: We are running versions 6.1/6.2/12.0 on a variety of hardware (5380/5400/5550).