NOLOCK for multiple tables
Posted by: Ra Nala
Date: November 17, 2015 07:30AM

Hi,

I am trying to apply NOLOCK syntax for my extraction query why because i am trying to load millions of records using one of the ETL tool called as PDI.

in this case i am trying to retrieve data from staging area and need to join with data mart table and should write into same data mart table. Is applying NOLOCK to my select query is good practice ??


Select * from course nolock

OR below is good practise ?

SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select * from course
go
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ

Thank you

Options: ReplyQuote


Subject
Written By
Posted
NOLOCK for multiple tables
November 17, 2015 07:30AM
November 17, 2015 12:10PM
November 18, 2015 01:41AM
November 26, 2015 04:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.