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
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
> 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
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
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
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