Re: OCP Question

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Wed, 20 Jun 2001 07:51:21 -0400
Message-ID: <3B308E39.76C8770B@cgi.ca>

Yes you're right...
Among other benefits it will reduce disk contention between the table and it's index..

Steve

"Thorsten Schütt" wrote:

> Given a table with millions of rows and an index on the table.
>
> What would be the best choice?
>
> a) Have table and index in the same tablespace on the same disk
> b) Have table and index in different tablespaces on the same disk
> c) Have table and index in different tablespaces on different disks
> d) All the same
>
> According to OFA, it must be c), am I right?
>
> Thanks in advance for your answer!
Received on Wed Jun 20 2001 - 06:51:21 CDT