Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> OCP Question

OCP Question

From: Thorsten Schütt <stylecouncil_at_t-online.de>
Date: Wed, 20 Jun 2001 09:08:47 +0200
Message-ID: <9gpi6e$4c7$05$1@news.t-online.com>

Given a table with millions of rows and an index on the table.

What would be the best choice?

  1. Have table and index in the same tablespace on the same disk
  2. Have table and index in different tablespaces on the same disk
  3. Have table and index in different tablespaces on different disks
  4. 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 - 02:08:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US