|
|
Archives of the TeradataForum
Message Posted: Tue, 15 Apr 2003 @ 11:08:01 GMT
Subj: | | Re: How to Disconnect Users During Loads |
|
From: | | Frank O Connor |
Hi
Automatically disconnecting users can have adverse consequences. This can depend on what they are doing.
However, if they are updating a table or inserting into a populated table, a rollback will result.This rollback may be more costly to the
system than having to wait for a user query to complete (especially as it may be nearly finished when your disconnect command is
issued).
Cheers
Frank
| |