/explore
|
You are here 
|
iusoltsev.wordpress.com | ||
| | | | |
rwijk.blogspot.com
|
|
| | | | | ||
| | | | |
kerryosborne.oracle-guy.com
[AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching. |
|
| | | | | ||
| | | | |
rwijk.blogspot.com
|
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
Here's a simple detail about bind peeking (during optimisation) that makes a big difference to "fetch first/next" queries. The optimizer knows about your bind types, and can peek at the bind values - but that doesn't mean it will do something sensible with them. Here's a little model to demonstrate the problem - starting with... |
|
| | | |||
