Re: Create Index with nologging?

updates? you're correct.

however, if I do

create table ....

create index ... no logging

THEN DO an update, the update gets logged.

If I then do

insert into table
select * from...

the index changes are NOT logged.

updates and insert into table values (...) get logged. bulk inserts (via select from) don't.

"Guruju,Narendra" <NGURUJU_at_cerner.com> wrote in message news:D15ED542E12BD3119FFE00805F6551F00BE369D9_at_mailwhqnews.cerner.com...
> Steve,
> alter index nologging will work only during the create. It has no affect
> once the index is created. So even with nologging option turned on
> inserts, updates to the index would still be logged on.
>
> -----Original Message-----
> From: Steve McDaniels [mailto:steve.mcdaniels_at_sierra.com]
> Posted At: Tuesday, July 24, 2001 5:50 PM
> Posted To: comp.databases.oracle.server
> Conversation: Create Index with nologging?
> Subject: Re: Create Index with nologging?
>
>
> You know you can alter index logging (or nologging) as often as you
> like.
> It only affects operations _after_ the alter statement.
>
> import your data.
> create index nologging
> [don't forget parallel (degree N)]
>
> when indexing complete,
> alter index logging
>
>
> "Peter Stryjewski" <pstryjew_at_worldnet.att.net> wrote in message
> news:3B5DED3B.F4F5365D_at_worldnet.att.net...
> > Hello,
> >
> > I have searched the Deja (now Google Groups) archives and the Ask Tom
> > page (how often does Tom take questions?) and found conflicting
 answers.
> >
> > Scenario, Oracle 8.1.x:
> >
> > Export DB from original system (with direct option for speed)
> > Move export file to new system
> > Use "indexfile" to get table create and index create statements
> > Create tables
> > Import Data without index build
> > ...
> > Now create indexes. This I would like to speed up!
> >
> > If I modify the index create statements, created by the "indexfile"
 and
> > add nologging (or is it norecovery?). This should speed things up.
> >
> > But what happens after the Create Index? I know I should take a
> > backup. But will all subsequent operations on the index be logged?
 Do
> > I have to ALTER the index, for this to happen? This is the portion
 with
> > a lot of conflicting information floating around.
> >
> > Does anyone have any good information on achieving the fastest import
> > and index build.
> >
> > Pete
>
>
Received on Fri Jul 27 2001 - 14:37:52 CDT