Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.8K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Session-level optimizer parameter to disable Nested Loops joins

Danilo Piazzalunga
Member Posts: 8 Blue Ribbon
On a large data warehouse and when running non-interactive, batch jobs, nested loops joins are almost always a bad idea.
Most often, they result from an incorrect execution plan based on incorrect cardinality estimates, caused by incorrect and/or stale statistics.
There should be either a session-level or a system-level parameter (or both) to instruct the optimizer never to use a nested loops join, as if the NO_USE_NL hint was being used on every table in the SQL query.
Comments
-
Agree in principle, however you'd also want to disable Merge Join Cartesian and probably some other things I haven't thought of.