Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: INDEXES: Parallel Index Jump to:  
Category: >> Oracle PL/SQL >> INDEXES: Parallel Index Bookmark and Share

<< lastnext >>

Snippet Name: INDEXES: Parallel Index

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.

Also see:
» INDEXES: View table indexes
» INDEXES: Analyze Index
» INDEXES: Block Dump
» INDEXES: Rebuild Reverse
» INDEXES:
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» INDEXES: Alter Index Parallel
» INDEXES: Alter Index Deallocate Unused
» INDEXES: Alter Index Allocate Extent
» INDEXES: Virtual / NoSegment
» INDEXES: Reverse Key Indexes
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» INDEXES: Unique indexes
» INDEXES: Compute Statistics
» INDEXES: SORT and NOSORT
» INDEXES: Function-Based Index
» INDEXES: DROP index
» INDEXES: Alter index
» INDEXES: Single Column Non-unique
» INDEXES: Index Usage Notes
» Compressed Indexes
» Create INDEX

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

CREATE INDEX <index_name>
ON <table_name> (<column_name_list>)
PCTFREE 0
PARALLEL (DEGREE <integer>)
TABLESPACE <tablespace_name>
 
-- for example: 
 
CREATE INDEX pidx_sales_region
ON sales_table(user_id, region)
PCTFREE 0
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:
 
ALTER INDEX [schema.]INDEX REBUILD [PARTITION partname] [ONLINE] [PARAMETERS 
(paramstring)][PARALLEL N];
 
-- NOTE: You cannot use PARALLEL with ONLINE.
 
/*
The syntax for paramstring is as follows:
 
paramstring = 
 
 
'REPLACE 
[datastore datastore_pref] 
[filter filter_pref] 
[lexer lexer_pref] 
[wordlist wordlist_pref] 
[storage storage_pref] 
[stoplist stoplist] 
[section group section_group]
[memory memsize]
[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 tag@attr
|    add stop section tag'
 
*/


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


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.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 51 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?