/explore
|
You are here 
|
kerryosborne.oracle-guy.com | ||
| | | | |
savvinov.com
Occasionally I encounter a situation when I need to affect a part of the plan that corresponds to a view, e.g.: Such situations are resolved using global hints. Oracle offers two ways to specify a global hint: via a query block identifier (system generated or user defined) or via view aliases. System-generated query block identifiers... |
|
| | | | | ||
| | | | |
leonotes.wordpress.com
transitive closure?Wiki?Oracle?... |
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few... |
|
| | | | | ||
| | | | |
oracle-base.com
ORACLE-BASE - Oracle 21c Articles |
|
| | | |||
