Outer Web | Explore

Explore >> Select a destination

You are here		akorotkov.github.io Thoughts About Jsonb Statistics - Alexander Korotkov's blog
\|	\|	nenadnoveljic.com Performance Problem with Incremental Statistics Calculation - All-round Database Topics	30.3 parsecs away Travel
\|	\|	A frequently executed SQL causes problems with the initial incremental statistics calculation.	30.3 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com NLS \| Oracle Scratchpad	36.7 parsecs away Travel
\|	\|	A couple of weeks ago, having just arrived home from Spain, I got a phone call in Heathrow airport from an old client that I hadn't seen for about 18 months. They had a problem; as far as they could tell a business critical query had suddenly stopped using an index and was doing a...	36.7 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	38.4 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...	38.4 parsecs away Travel
\|	\|	nenadnoveljic.com Performance Improvement on Dictionary Views in Oracle 21c - All-round Database Topics	51.0 parsecs away Travel
\|		Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD.	51.0 parsecs away Travel