Archives of the TeradataForum
Message Posted: Wed, 11 Apr 2001 @ 16:40:04 GMT
Mark's right. If you ever have performance problems querying system tables, have a look at the view that you are going through and base your sql on the view definition.
Common ways of making it go faster (both of which are shown in Mark's sql);
1 - remove any unwanted tables. A lot of the standard system views join multiple tables. This is fine/correct for what the view is intended to show, but does tend to slow them down.
2 - try to use the PI columns of the underlying tables, DatabasenameI is the PI for the database/user table (DBC.Dbase).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|