LOGGING/NOLOGGING Clause
423371Nov 3 2005 — edited Nov 3 2005I am running an insert statement, my insert statement selects 8 million rows from table B and inserts into table A
insert into tableA (...)
select ... from tableB
I have altered both the tables to have NOLOGGING option.
Do you think this is the right way to do or I should turn NOLOGGING on tableA and LOGGING on tableB
Since it involves the insert and select of 8 millions I am converned about the performance and time it takes for the Insert to complete
Any suggestions and inputs would help
Thanks