Oracle kill the myth!
Today I had some doubts about some myths… or suposed myths. Some years ago I’ve learned in Oracle Tuning courses (Oracle University) that using different tablespaces for indexes and data is good performance measure. After a OTN post about APEX performance Tyler, a proeminient Oracle staff person, linked me to a Tom Kyte post that assures that managin indexes and datain different tablespaces does not mean performance.
In the same post I saw that there are other Oracle users that learn what I also learn in Oracle courses, and Jefrey commented what we all learn at Oracle University courses.
I went and confirmed that in the “Oracle OCP Oracle 9i Database: Performance Tuning Exam Guide”, Charles A Pack, Editor, Oracle Press, Chapter 7, page 147: “Table and Index Segments – Keep index segments separate from their associated table segments.” The chapter states the idea at least three times. If you want to kill this myth, you might want to ask the other branches of the Oracle corporation to stop printing it.
So, what you think about this? Do you data and indexes should be in different tablespaces? comment me… Just to kill the myth 🙂