Re: should you separate indexes from tables in separate dataf

2003-07-16 Thread Dwayne Cox
On a related note: We recently installed an app from a vendor and I noticed that the installer stored the indexes in the same tablespace as the data (even though I had a separate tablespace just for indexes). Should I take the time now to separate the two? My gut says yes. Sorry if this is a

RE: RE: should you separate indexes from tables in separate dataf

2003-07-15 Thread DENNIS WILLIAMS
R, My personal theory on where this started was benchmarking. Before the Oracle Wait Interface was developed, about the only hard-core information you could get on tuning came as a result of people running benchmarks. If you benchmark a batch program by itself that uses an index to access a tabl

RE: RE: should you separate indexes from tables in separate dataf

2003-07-15 Thread rgaffuri
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: should you separate indexes from tables in separate dataf > > R, >My personal theory on where this started was benchmarking. Before the > Oracle Wait Interface was developed, about the onl

RE: RE: should you separate indexes from tables in separate dataf

2003-07-15 Thread DENNIS WILLIAMS
as a data publication model where you ingest deltas? any data on this? > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]> > Date: 2003/07/15 Tue PM 12:04:24 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: should you separate indexes from tab

Re: RE: should you separate indexes from tables in separate dataf

2003-07-15 Thread Tanel Poder
S <[EMAIL PROTECTED]> > > Date: 2003/07/15 Tue PM 12:04:24 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: RE: should you separate indexes from tables in separate dataf > > > > R, > >My personal theory on

Re: RE: should you separate indexes from tables in separate dataf

2003-07-15 Thread Arup Nanda
t mount > > points in an instance used for batch loads? such as a data publication > model > > where you ingest deltas? > > > > any data on this? > > > > > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]> > > > Date: 2003/07/15 Tue PM 12:04:24 EDT