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

Home -> Community -> Usenet -> c.d.o.server -> Re: Basic Oracle8i

Re: Basic Oracle8i

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/04/12
Message-ID: <38F4533F.1FD0@yahoo.com>#1/1

Jim Lewis wrote:
>
> After several years working with mainframe DB2, then a few years with
> Sybase on a Sun, I'm taking a look at Oracle8i running on Linux.
>
> It's running at last, and I'm creating "schema" objects and I haven't
> yet found answers to a couple of very basic questions.
>
> 1. What is the Oracle functional equivalent to what in DB2 and Sybase
> is called a "clustering" index?
>
> 2. What is the best practices procedure for creating indexes - - is
> it best to create them before a table is loaded with data or after?
>
>
>

  1. I don't know Sybase but I'd guess its the same (or similar) to an index organised table, that is, a table whose internal structure is that of a B-tree index.
  2. Definitely after for bulk load operations - of course, if its an index used to do things validate uniqueness, then you may need it as you add rows.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Wed Apr 12 2000 - 00:00:00 CDT

Original text of this message

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