|
You are here |
jonathanlewis.wordpress.com | ||
| | | | |
www.dbaglobe.com
|
|
| | | | | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. | |
| | | | |
sqlmaria.com
|
|
| | | | | At the recent OUG Ireland conference I had the privilege of participating in a panel discussion on the Oracle Database. During the course of the session the topic of Optimizer histograms came up. A... | |
| | | | |
leonotes.wordpress.com
|
|
| | | | | ????????transitive closure?Wiki??????????Oracle????????... | |
| | | | |
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... | ||