Re: table_space problem

dhiltz_at_whsun1.wh.whoi.edu (David Hiltz) writes:

> I have my users do all there work outside of SYSTEM (like I said above).
> I don't know of any advantage for creating indexes in seperate tablespaces
> from where other objects are created (such as a user's default tablespace).

If you have a special tablespace for indices that lives on a different disk then disk contention is lowered often, and thus performance can be enhanced

-- 
David T. Bath             | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)
Senior Tech Consultant    | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
Global Technology Group   | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
"The robber of your free will does not exist" - Epictetus