Archives of the TeradataForum

Message Posted: Wed, 11 Apr 2001 @ 16:40:04 GMT

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

Leszek,

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

Cheers,

Dave

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