Explore >> Select a destination
|
You are here 
|
dioncho.wordpress.com | ||
| | | | |
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... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
hourim.wordpress.com
|
|
| | | | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | |
| | | | |
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... | ||
