Explore >> Select a destination
|
You are here 
|
www.dbaglobe.com | ||
| | | | |
leonotes.wordpress.com
|
|
| | | | | ????????transitive closure?Wiki??????????Oracle????????... | |
| | | | |
kerryosborne.oracle-guy.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... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | I've lost count of the number of times I've reminded people that hinting (correctly) is hard. Even the humble /*+ index() */ hint and its close relatives are open to misunderstanding and accidental misuse, leading to complaints that "Oracle is ignoring my hint". Strange though it may seem, I'm still not 100% certain of what... | ||
