Explore >> Select a destination

You are here

 tanelpoder.com
COUNT STOPKEY operation (the where ROWNUM <= N predicate) doesn't process over ~4 Billion rows and returns wrong results | Ta...
| | dioncho.wordpress.com
_gby_hash_aggregation_enabled bug | Dion Cho - Oracle Performance Storyteller
9.2 parsecs away

Travel
| | One of the customers complained that Oracle refuses to use the HASH GROUP BY operation under any circumstances. It's 10gR2(10.2.0.1) database. See that Oracle simply refuses to use HASH GROUP BY operation even with the simplest group by? You might think that the "_gby_hash_aggregation_enabled" would have been false which is clearly right. But even with...
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
7.7 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...
| | jonathanlewis.wordpress.com
Ignoring Hints - 2 | Oracle Scratchpad
11.6 parsecs away

Travel
| | Here's a little puzzle that someone sent to me a couple of days ago - it's a case where the optimizer seems to be ignoring a hint. Notice that the only difference between these two queries is the filter predicate: t1.id = 1 in the first statement and t2.id = 1 in the second. Given...
| | tonyhasler.wordpress.com
Parallel partition scans | Tony's Oracle Tips
113.2 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...