title: Oracle SQL different plan for same query on different environments
body: <p>Two very similar environments, same database structure, one query, two execution plans: one with nested loops and indexes (fast), another with hash joins and full access (slow).</p>
  
  <p>Which steps should I perform to find the cause of plans difference?</p>