CREATE INDEX matable_part ON matable(colonne) GLOBAL PARTITION BY RANGE (colonne)( PARTITION part_1 VALUES LESS THAN (100000) , PARTITION part_2 VALUES LESS THAN (2000000) , PARTITION part_max VALUES LESS THAN (MAXVALUE)  )