ORACLE HINT REFERENCE PARALLEL Scanning full table with parallel degree of 8. Parallel always assumes full table scan. SELECT /*+ FULL(hr_emp) PARALLEL(hr_emp, 8 ) */ last_name FR… more →
Mohib Alviwrote 11 months ago: In my previous article – http://avdeo.com/2012/06/20/fixing-sql-plans-the-hard-way-part-1/ … more →
wrote 12 months ago: This article is about fixing a plan for SQL statement in a hard way. Till now we have seen that prof … more →
wrote 4 years ago: ORACLE HINT REFERENCE PARALLEL Scanning full table with parallel degree of 8. P … more →