Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database

Improving Index Creation Efficiency

The speed with which you can create an index is always critical when you're creating indexes on large tables. You can adopt several strategies to minimize the index creation time, as summarized in the following sections. Often, you can combine several of these strategies to cut short the time for creating an index.

Parallelizing Index Creation

Using the parallel option during index creation will help speed up the creation of a large index. In order to create an index, the database needs to perform a full table scan. Specifying the parallel clause makes the database perform the full table scan in parallel, thus making the index creation finish much faster. There is no hard and fast rule, of course, as to the ...