Archives of the TeradataForum
Message Posted: Fri, 08 Mar 2002 @ 14:07:00 GMT
Yet another difference, - is the granularity of the (write) locking in Teradata - compared to Oracle.
Somewhere in the Teradata documentation there is quite profound locking summary table, describing the update select statement referred columns and the behviour if those referred columns are UPI, NUPI, USI, NUSI or no index.
As far as I understand this table correctly, you easily lock more rows with Teradata update statements than you would with Oracle row- level locking.
(This may be derived from the Teradata 'share-nothing' parallel architecture.)
Teradata is more focused to DWH than to OLTP.
I would consider this suggestion in case you make long term transactions with Teradata.
If you only have single update process and multiple read the Teradata 'dirty-reads' work OK - if they do not cause too confusing results to the reader processes ...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|