Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Move of system data from Teradata to Access
From:   David Wellman


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



  <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: 15 Jun 2023