Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Move of system data from Teradata to Access
 
From:   Leszek Kosinski

My web interface is querying a DBC.Users system view to obtain a user's password change date with a following SQL command.

SELECT username, passwordchgdate FROM dbc.users WHERE UserName = 'test2'

The problem is that it takes too much time to get a response - over 1 minute which the client does not accept. Is there a more efficient way of writting this SQL to make it run faster or if not what are the out of the box or easy to implement solutions to copy the information : user, passwordchangewdate from Teradata v2r3 dbc.users table into a table in Microsoft Access?


Thanks,

Leszek



     
  <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