Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespaces and indexes
Thanks a lot.
"Michiel Brunt" <mbrunt_at_inergy.nl> wrote in message
news:9ock03$6lj$1_at_scavenger.euro.net...
> We created a data warehouse with data spread over multiple tablespaces.
> Large tables have their own, others share a tablespace.
> In a book about database tuning I read that indexes should be placed in
the
> same tablespace as the table it is built on.
> However, I have heard others say it is better to store indexes in a
seperate
> index tablespace.
>
> Who can tell me what is best for performance?
>
> Thanks, Michiel
>
>
Received on Thu Sep 20 2001 - 08:27:38 CDT