 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Sep 2003 @ 18:02:02 GMT
| Subj: | | Re: Locking issue with views |
| |
| From: | | Fuller, Joe |
In the view...
REPLACE VIEW AS
LOCKING TABLE FOR ACCESS
LOCKING TABLE FOR ACCESS
LOCKING TABLE FOR ACCESS
SELECT ...
;
As long as "dirty" reads are acceptable this is the way around the read locks and what we use in all of our production implementations.
(Keeps user queries from interfering with ETL jobs.)
Best Regards,
Joe Fuller
Sr Data Warehouse Consultant, DBA
Teradata Professional Services
| |
