Archives of the TeradataForum

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

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

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