As a newbie to the Oracle DBA world, I have had the exact OPPOSITE philosophy engrained into my head by our lead-DBA. Could you explain this myth of separating indexes & tables?
Originally posted by slimdave
Definately not a tall story though, when it is endorsed by tom. There are other things to look at first in db tuning -- reduce your logical i/o's, use bind variables, make good use of your cpu's, for example. Oh, and if anyone tells you to separate indexes and tables into different tablespaces for performance reasons, make a mental note to pay no further attention to them. Another myth.