Archives of the TeradataForum
Message Posted: Wed, 20 Sep 2000 @ 04:39:24 GMT
| Subj: || || Re: Access logging and utilities |
| From: || || Karen Gebhard |
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.