patternMinor
Where all can the /*+ PARALLEL */ hint be used?
Viewed 0 times
cantheallhintusedwhereparallel
Problem
It works with SELECT and UPDATE statements.
Are there some more statements with which it works?
I was able to use it with create, but am not sure if the hint was actually considered.
Except INSERT and UPDATE, when all is the PARALLEL hint considered?
Are there some more statements with which it works?
I was able to use it with create, but am not sure if the hint was actually considered.
SQL> create /*+ PARALLEL */ table t1
( id number,
name varchar2(40));
Table created.
SQL>Except INSERT and UPDATE, when all is the PARALLEL hint considered?
Solution
The Data Warehousing Guide has a chapter on parallel operations that goes over what operations can be parallelized.
You can't parallel-ize a simple CREATE TABLE statement (nor would you want to-- there wouldn't be enough work to be able to parcel it out to multiple worker threads). You can, however, parallel-ize a CREATE TABLE AS SELECT statement either by specifying the PARALLEL hint in the SELECT or by using the PARALLEL keyword in the CREATE.
You can't parallel-ize a simple CREATE TABLE statement (nor would you want to-- there wouldn't be enough work to be able to parcel it out to multiple worker threads). You can, however, parallel-ize a CREATE TABLE AS SELECT statement either by specifying the PARALLEL hint in the SELECT or by using the PARALLEL keyword in the CREATE.
Context
StackExchange Database Administrators Q#1267, answer score: 6
Revisions (0)
No revisions yet.