Re:NO SORT parameter

From: <dgoulet_at_vicr.com>
Date: Wed, 6 Dec 2000 13:42:09 -0500
Message-Id: <10702.123816@fatcity.com>

Create table does not have a NO SORT option, only create index. To use the NO SORT option the data inside of the table has to have been loaded in a sorted order. If it was done in a random order then it will fail. The advantage is that you don't have to go through the sort when creating the index. Can save time, but rarely succeeds.

Dick Goulet.

____________________Reply Separator____________________

Subject: NO SORT parameter
Author: cemail_at_sprintmail.com
Date: 12/6/2000 9:16 AM

Are there any disadvantages to using NO SORT in creating an index? This is an index on a data warehouse table.

Also, somebody told me that CREATE TABLE had some sort of NO SORT parameter as well, but I don't see it anywhere and it doesn't really make sense to me. Anybody heard anything like this?

We are running 8.0.5 on HPUX.

Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: cemail_at_sprintmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 06 2000 - 12:42:09 CST