Archives of the TeradataForum
Message Posted: Wed, 11 Apr 2001 @ 16:06:40 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|