Re: Basic Oracle8i

From: Anne Crowther <anne.crowther_at_nospam.capgemini.co.uk>
Date: 2000/04/12
Message-ID: <8d1t9f$ok1$1@taliesin2.netcom.net.uk>#1/1

Answer to 2. is: After

Not knowing DB2 or Sybase I won't attempt to answer 1. - there's bound to be someone else who definitely knows!

Cheers,

Anne

--
email: acrowther_at_my-deja.com



Jim Lewis <pojpl_at_ais.ucla.edu> wrote in message
news:8d049i$8a0$1_at_carroll.library.ucla.edu...


> 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?

>

>

>

>

>

>

>

Received on Wed Apr 12 2000 - 00:00:00 CDT