Re: Basic Oracle8i

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