Tags » Partitioning

12cR2 Partitioning: auto-list and the disk space threat

Oracle 12cR2 comes with the auto-list partitioning option; It allows for system named partitions to be created on the fly as data arrives:

SQL> select banner from v$version where rownum=1;

Oracle Database 12c Enterprise Edition Release - 64bit Production

SQL> create table auto_list_part
  	( n1 number  
       ,n2 number 
       ,vc1 varchar2(30)
     partition by list(n1)
     (partition p1 values(1,2,3,4,5)
     ,partition p2 values(6,7,8,9,10)
     ,partition p3 values(11,12,13,14,15) 
… 1,714 more words

Demantra Performance Tuning

Last month, was engaged in the tuning of Demantra applications and found below two solutions which are extremely helpful

1. Partitioning of SALES_DATA table

(a) 247 more words


Index Bouncy Scan 4

There’s always another hurdle to overcome. After I’d finished writing up the “index bouncy scan” as an efficient probing mechanism to find the combinations of the first two columns (both declared not null) of a very large index a follow-up question appeared almost immediately: … 2,663 more words


Min/Max upgrade

Here’s a nice little optimizer enhancement that appeared in 12.2 to make min/max range scans (and full scans) available in more circumstances. Rather than talk through it, here’s a little demonstration: 977 more words


Beyond Partitioning Table, A step further

In the previous post, Partitioning in SQL Server , It was explained how to partition a table by creating partition function, scheme and filegroups. The final result looked something like this: 629 more words

Sql Server

Partitioning in SQL Server

SQL Server supports table and index partitioning, which basically divides the data horizontally into multiple filegroups in a database. The benefits of partitioning a large table are: 546 more words

Sql Server

Leap 15.0 -- the partitioner

It is expected that Leap 15.0 will be released by the end of this month (May 2018).  At present, I have Build 241.1 installed for testing.  1,121 more words