Hi Team,
I have 2 scenario,
1. No logging with CREATE TABLE AS SELECT
create table test_objects NOLOGGING
as
SELECT
a.owner,
a.object_name,
a.subobject_name,
a.object_id,
a.object_type,
a.status
FROM
all_objects a;
2. Create table first with NO LOGGING then insert into table
CREATE TABLE test_objects
( owner varchar2(128) NOT NULL ENABLE
,object_name VARCHAR2(128) NOT NULL enable
,subobject_name VARCHAR2(128)
,object_id NUMBER NOT NULL ENABLE
,object_type VARCHAR2(23)
,status VARCHAR2(7) ) nologging;
and then
insert /*+ append */ into test_objects
SELECT
a.owner,
a.object_name,
a.subobject_name,
a.object_id,
a.object_type,
a.status
FROM
all_objects a;
when I execute both, second approach is taking more time compare to first approach. Is there any specific reason for this.
I have attached screenshots for time execution
Thanks,
Asha