Archives of the TeradataForum

Message Posted: Wed, 20 Sep 2000 @ 04:39:24 GMT

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

Thanks - you're right, my users access data through views so I could only log the updates, deletes and inserts via the views rather than the physical tables. And i should also log the selects to see if the queries are being built as efficiently as possible plus that they are using the highest level of summary data that will give them their answer. Right now my users have only queryman as a tool and most of them have not had sql training. So this will give me a way of monitoring what they are writing and how long it is running.

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