Re: Why "Separating Data and Indexes improves performance" is a myth?

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 26 Apr 2004 13:41:16 -0400
Message-ID: <005c01c42bb5$ad8b50c0$2501a8c0@dazasoftware.com>

Thanks to every one who answered
The conclusion is, about the specific question, (for small database at least)
The data and indexes are accesed serially, maybe in the past there could be some benefit, but now you don't get an important improvement setting data and indexes in distinct tablespaces and they in distinct physical disks.

:)

Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Apr 26 2004 - 12:43:35 CDT