Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: OCP Question
Separating them is always a good policy. Another item to consider is the configuration of your storage. For instance, if you have have two disk banks each controlled by a different controller it would be best to put the tables on a disk of one controller and the indexes on the disk of the second controller.
javadude (I haven't always been a developer)
"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 - 16:46:17 CDT