Explore >> Select a destination
|
You are here 
|
www.xt-r.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... | |
| | | | |
oracle-randolf.blogspot.com
|
|
| | | | | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these... | |
| | | | |
antognini.ch
|
|
| | | | | ||
| | | | |
sqlmaria.com
|
|
| | | In a recent chat with Connor McDonald, we discussed if it is realistic to have applications that don't contain Optimizer hints. Ideally, the answer to this question is "yes", you don't need hints i... | ||
