Outer Web | Explore

Explore >> Select a destination

You are here		www.bobbydurrettdba.com Cardinality errors across joins \| Bobby Durrett's DBA Blog
\|	\|	jonathanlewis.wordpress.com Bind Peeking \| Oracle Scratchpad	2.1 parsecs away Travel
\|	\|	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...	2.1 parsecs away Travel
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	2.0 parsecs away Travel
\|	\|	When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...	2.0 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))	1.9 parsecs away Travel
\|	\|	A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	1.9 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com use_nl hint \| Oracle Scratchpad	21.7 parsecs away Travel
\|		In response to a recent lamentation from Richard Foote about the degree of ignorance regarding the clustering_factor of indexes I commented on the similar degree of ignorance regarding the syntax of a specific hint, namely use_nl(a b), pointing out that this does not mean "do a nested loop from a to b". My comment was...	21.7 parsecs away Travel