Description: Parallel index creation is often used when importing data warehouse tables. They're also useful for administrators who need to rebuild indexes that have spawned too many levels or contain too many deleted leaf rows.
The DEGREE parameter specifies the parallel degree for parallel indexing. This parameter is supported only when you use sync, replace, and resume in paramstring. The actual degree of parallelism might be smaller depending on your resources.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
PARALLEL (DEGREE <integer>)
TABLESPACE <tablespace_name>-- for example: CREATEINDEX pidx_sales_region
ON sales_table(user_id, region)PCTFREE0
PARALLEL (DEGREE 4)
TABLESPACE sales_us;-- The following syntax is used to rebuild the index, rebuild an -- index partition, resume a failed operation, perform batch DML, -- add stopwords to index, add sections and stop sections to -- index, or optimize the index:ALTERINDEX[schema.]INDEX REBUILD [PARTITION partname][ONLINE][PARAMETERS
(paramstring)][PARALLEL N];-- NOTE: You cannot use PARALLEL with ONLINE./*
The syntax for paramstring is as follows:
[section group section_group]
[index set index_set]
| resume [memory memsize]
| optimize [token index_token | fast | full [maxtime (time | unlimited)]
| sync [memory memsize]
| add stopword word [language language]
| add zone section section_name tag tag
| add field section section_name tag tag [(VISIBLE | INVISIBLE)]
| add attr section section_name tag [email protected]
| add stop section tag'
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.