Tags » Partitioning

Virtual Partitions

Here’s a story of (my) failure prompted by a recent OTN posting.

The OP wants to use composite partitioning based on two different date columns – the table should be partitioned by range on the first date and subpartitioned by month on the second date. 1,078 more words

Oracle

Questions & Answers

1 – What is the difference between MySQL & SQLite & PostgreSQL?
2 – What is the diference between AngularJs & React?
3 – What is the difference between OAuth Client Profiles ? 58 more words

Web Development

Alternative for MySql indexes when querying a heavy transactional db - Partioning

We always search for improving the query performance and end up with Indexes. 

I too love Indexes when it comes for performance tuning over a table on which we perform more retrieval than manipulation. 455 more words

MySql

DDL logging

I was presenting at the UKOUG event in Manchester on Thursday last week (21st April 2016), and one of the sessions I attended was Carl Dudley’s presentation of some New Features in 12c. 404 more words

Oracle

Partitioning - RANGE INTERVAL

1.) Create table:

drop table cmagno.test_pt_int;  
create table cmagno.test_pt_int (
  num number,
  text varchar2(1000),
  dt date
)
PARTITION BY RANGE (dt) INTERVAL (NUMTODSINTERVAL (1, 'DAY'))
( 
   PARTITION p1 VALUES LESS THAN (TO_DATE('08-04-2016', 'DD-MM-YYYY'))
); 

2.) Inserting Data:


declare

i number;
v_dt date;

begin

  for i in 1..100 loop    
      v_dt := trunc(sysdate+i);
      insert into cmagno.test_pt_int 
      values (i,'DATE: ' || to_char(v_dt) ,v_dt);
  end loop;
  commit;

end;
/

3.) Stats:

exec dbms_stats.gather_table_stats('CMAGNO','TEST_PT_INT');

4.) Partitions:

select count(*) 
from dba_tab_partitions 
where table_name='TEST_PT_INT';

            COUNT(*)
--------------------
                 101

1 row selected. 203 more words

wiping out a GPT partition table

I’m assuming that sdb is the disk you are working on.

To just get rid of the gpt:
sudo sgdisk -z /dev/sdb

To get rid of the gpt and mbr:
sudo sgdisk -Z /dev/sdb

Linux

Update to TRUNCATE TABLE in SQL 2016 (partition support)

Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.

This change allows you to truncate an individual partition, instead of having to switch that partition out to another table and then truncate it. 546 more words

Partitioning