RE: Question on diff block sizes in DB

From: Hitchman, Peter <Peter.Hitchman_at_thomson.com>
Date: Sun, 18 Apr 2004 06:46:52 +0100
Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E02DA81@der-lon-msg-03.derwent.co.uk>

Hi,
Just picking out the point you made about indexes. What benefits have you observed by having indexes in a tablespace with a different block size from its table?

Regards

Pete

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: 17 April 2004 23:37
To: oracle-l_at_freelists.org
Subject: Re: Question on diff block sizes in DB

The main thing that must be understood is that one can have a table in 16k tablespace and an index in 8k tablespace.

--

Mladen Gogala
Oracle DBA

---

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

---

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

---

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 Sun Apr 18 2004 - 00:45:27 CDT