/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 tonyhasler.wordpress.com
The importance of the GLOBAL_STATS statistic on partitioned tables | Tony's Oracle Tips
| | antognini.ch
Partition-Wise Operations - New Features in 12c and 18c - Striving for Optimal Performance
3.0 parsecs away

Travel
| | [AI summary] This article details new SQL features in Oracle 12c and 18c that enhance partition-wise operations for GROUP BY, DISTINCT, and windowing functions to improve parallel query performance.
| | jonathanlewis.wordpress.com
Re-partitioning 2 | Oracle Scratchpad
4.1 parsecs away

Travel
| | Last week I wrote a note about turning a range-partitioned table into a range/list composite partitioned table using features included in 12.2 of Oracle. But my example was really just an outline of the method and bypassed a number of the little extra problems you're likely to see in a real-world system, so in this...
| | nenadnoveljic.com
Undocumented Implicit Partition Statistics Gathering - All-round Database Topics
2.7 parsecs away

Travel
| | A boundary condition where subpartition statistics gathering can also trigger partition statistics
| | oracle-randolf.blogspot.com
Oracle related stuff: New Parallel Distribution Method For Direct Path Loads
16.1 parsecs away

Travel
| Starting with version 12c Oracle obviously has introduced another parallel distribution method for direct path loads (applicable to INSERT A...