Blogs about: Sql Hints

Featured Blog

SQL optimization using Oracle Hints

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 Alvi

Fixing SQL Plans: The hard way - Part 2 — 2 comments

advait wrote 11 months ago: In my previous article – http://avdeo.com/2012/06/20/fixing-sql-plans-the-hard-way-part-1/ … more →

Tags: Database 10g Performance Tuning, Oracle database 11g, sql_profile, create sql_profile, import sql profile, SQL tuning

Fixing SQL Plans: The hard way - Part 1 — 9 comments

advait 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 →

Tags: Oracle database 11g, sql_profile, create sql_profile, import sql profile, SQL tuning

SQL optimization using Oracle Hints

mohibalvi wrote 4 years ago: ORACLE HINT REFERENCE       PARALLEL Scanning full table with parallel degree of 8. P … more →

Tags: SQL OPTIMIZATION, cpu_costing, no_cpu_costing


Related Tags
All →

Follow this tag via RSS