How does one invoke Parallel Query?
Submitted by admin on Tue, 2004-09-21 22:45.
After setting the INIT.ORA parameters necessary for Parallel
Query to work, do the following:
- Alter the table (or index) to indicate that Oracle should try to parallelize operations performed against it
ALTER TABLE table_name PARALLEL (DEGREE 8); - Put hints in SQL statements to indicate that Oracle should try to execute them in parallel:
SELECT --+ PARALLEL(table_alias, degree, nodes) * FROM table_name ...SELECT /*+PARALLEL(table_alias, degree, nodes)*/ * FROM table_name ...
»
- Login to post comments

