Outer Web | Explore

Explore >> Select a destination

You are here		www.dbaglobe.com Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins
\|	\|	karenmorton.blogspot.com Karen Morton: 2013 - Webinar Recordings	2.3 parsecs away Travel
\|	\|	Becoming an Everyday Oracle Pro (2013 November 12) SQL Tuning Fundamentals - Execution Plans (2013 September 17) Visual SQL Tun...	2.3 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com dbms_xplan - again \| Oracle Scratchpad	2.5 parsecs away Travel
\|	\|	I've discussed the capabilities of the dbms_xplan package in a couple of posts already; and shown how useful it can be in two examples: understanding a problem with filter subquery selectivity and understanding why some Cartesian merge joins were appearing unexpectedly. Let me make a crucial point about execution plans (again): if you have a...	2.5 parsecs away Travel
\|	\|	optimizermagic.blogspot.com Inside the Oracle Optimizer - Removing the black magic: What's Changed between my New Query Plan and the Old One?	2.2 parsecs away Travel
\|	\|	This blog post has moved here http://blogs.oracle.com/optimizer/entry/whats_changed_between_my_new_query_plan_and_the_old_one	2.2 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	13.6 parsecs away Travel
\|		When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE\|LIST\|HASH] ITERATOR or PX PARTITION [RANGE\|LIST\|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...	13.6 parsecs away Travel