Outer Web | Explore

Explore >> Select a destination

You are here		sqlmaria.com How to determine which view is the right view to use in Oracle?
\|	\|	www.bobbydurrettdba.com Cardinality errors across joins \| Bobby Durrett's DBA Blog	6.5 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...	6.5 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)	5.7 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.	5.7 parsecs away Travel
\|	\|	connor-mcdonald.com Kris Kringle the Database - Getting the BAND together - Learning is not a spectator sport	8.3 parsecs away Travel
\|	\|	Ever heard of a BAND join? It's not actually new, it has been around since 12.2. Jonathan Lewis wrote up a nice post on it was back in 2017 but in a nutshell MERGE join done without a band join SQL> select 2 e1.last_name\|\| ' has salary roughly between '\|\| e2.last_name comparison 3 from 4...	8.3 parsecs away Travel
\|	\|	dban00b.wordpress.com Latch free waits, Dynamic Statistics, and the Result Cache - DBA n00b	55.1 parsecs away Travel
\|		2016-11-29 EDIT: Oracle has announced that in 12.2 the features that drove this overuse of the result cache (dynamic stats triggered by SPDs) will default to off, and provided patches to apply to 12.1 as well. More info here. Also, some investigation by Mauro Pagano around the impact of the new OPTIMIZER_ADAPTIVE_STATISTICS parameter turned up...	55.1 parsecs away Travel