| Title: | Oracle |
| Notice: | For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010 |
| Moderator: | EPS::VANDENHEUVEL |
| Created: | Fri Aug 10 1990 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1574 |
| Total number of notes: | 4428 |
I have a Question at Oracle Create Index Option. I try to SQL-Loader(rows,skip,load option) Sandy-san's sample sctipt used. it is very fast. Thank you!! but, I try to Create Index (NOSORT option) isn't work. very slowly (ORA-01409: NOSORT option may not be used: rows are not in ascending order). now I used create index ... "unrecoverable parallel (degree 6) option" Do you have any ideas more faster create index any other options ? Thanks your help. Yasuhiro. MCS/DEC-J
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1525.1 | Speedup building indexes. | AXPBIZ::RANJAN | Mon Mar 10 1997 16:33 | 12 | |
The CREATE INDEX with the NOSORT option will work only if the data in the table is actually in sorted order. NOSORT option is pretty good. But the parallel and unrecoverable options work effectively. How much of sort area are you having ? I had done some experiments last year on tuning creation of indexes in an Oracle7 database. A whitepaper on this is available at our group's web-site at http://www-spe.pa.dec.com/groups/dbtc/documents/ Its called "Creating Indexes in Oracle - A Closer Look". It might be useful for you. - Ranjan. | |||||