After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
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';
|
|
|
|
