Oracle PL-SQL allows parallel hints to be added at the session and
query level.
Caution should be used when using parallel hints - it can actually
slow down queries in many cases!
-- Session level, enable parallel processing
execute immediate ('alter session enable parallel dml');
-- Query level hint
select account_id /*+ parallel index (t1 idx_invoice_region) */
from invoice_region
where sales_region = 'TGX';
|
|
