Outer Web | Explore

Explore >> Select a destination

You are here		tanelpoder.com Advanced Oracle SQL Tuning Training \| Tanel Poder Blog
\|	\|	www.bobbydurrettdba.com Cardinality errors across joins \| Bobby Durrett's DBA Blog	4.6 parsecs away Travel
\|	\|	We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned...	4.6 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com Plans in Memory \| Oracle Scratchpad	3.8 parsecs away Travel
\|	\|	In an earlier articleI described how dbms_xplan.display_cursor() could be used to query memory to find the execution plans (and row source statistics) of recently executed SQL. In 9i, you have to use your own SQL to get the equivalent results. If you do, you should avoid using the "traditional" hierarchical type of query that you...	3.8 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins	2.6 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.	2.6 parsecs away Travel
\|	\|	blog.jooq.org What's faster, COUNT() or COUNT() with LIMIT in SQL? Let's check	30.3 parsecs away Travel
\|		We check execution plans and benchmark results to see if using a LIMIT clause is useful when checking for existence of N values in SQL	30.3 parsecs away Travel