After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent Friday fish fry!
|
Oracle
»
PL-SQL
»
Coding
»
Performance
Parallel Query Processing
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';
|
|
|
|
