1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| CREATE INDEX ENTR.IDX_CLIENT_BR_TEST ON ENTR.CLIENT_BR ( COD_PRD_REF ASC,
ENTITE ASC,
ID_LOCAL_TIERS ASC
)
PARTITION BY RANGE
(PARTITION 200801 ENDING AT ('200802') ,
PARTITION 200802 ENDING AT ('200803') ,
PARTITION 200803 ENDING AT ('200804') ,
PARTITION 200804 ENDING AT ('200805') ,
PARTITION 200805 ENDING AT ('200806') ,
PARTITION 200806 ENDING AT ('200807') ,
PARTITION 200807 ENDING AT ('200808') ,
PARTITION 200808 ENDING AT ('200809') ,
PARTITION 200809 ENDING AT ('200810') ,
PARTITION 200810 ENDING AT ('200811') ,
PARTITION 200811 ENDING AT ('200812') ,
PARTITION 200812 ENDING AT ('200812') ,
PARTITION 200901 ENDING AT ('200901') ,
PARTITION 200902 ENDING AT ('200902') ,
PARTITION 200903 ENDING AT ('200903') ,
PARTITION 200904 ENDING AT ('200904') ,
PARTITION 200905 ENDING AT ('200905') ,
PARTITION 200906 ENDING AT ('200906') ,
PARTITION 200907 ENDING AT ('200907') ,
PARTITION 200908 ENDING AT ('200908') ,
PARTITION 200909 ENDING AT ('200909') ,
PARTITION 200910 ENDING AT ('200910') ,
PARTITION 200911 ENDING AT ('200911') ,
PARTITION 200912 ENDING AT ('200912') ,
PARTITION 201001 ENDING AT ('201001') ,
PARTITION 201002 ENDING AT ('201002') ,
PARTITION 201003 ENDING AT ('201003') ,
PARTITION 201004 ENDING AT ('201004') ,
PARTITION 201005 ENDING AT ('201005') ,
PARTITION 201006 ENDING AT ('201006') ,
PARTITION 201007 ENDING AT ('201007') ,
PARTITION 201008 ENDING AT ('201008') ,
PARTITION 201009 ENDING AT ('201009') ,
PARTITION 201010 ENDING AT ('201010') ,
PARTITION 201011 ENDING AT ('201011') ,
PARTITION 201012 ENDING AT ('201012') ,
PARTITION 201101 ENDING AT ('201101') ,
PARTITION 201102 ENDING AT ('201102') ,
PARTITION 201103 ENDING AT ('201103') ,
PARTITION 201104 ENDING AT ('201104') ,
PARTITION 201105 ENDING AT ('201105') ,
PARTITION 201106 ENDING AT ('201106') ,
PARTITION 201107 ENDING AT ('201107') ,
PARTITION 201108 ENDING AT ('201108') ,
PARTITION 201109 ENDING AT ('201109') ,
PARTITION 201110 ENDING AT ('201110') ,
PARTITION 201111 ENDING AT ('201111') ,
PARTITION 201112 ENDING AT ('201112') ,
PARTITION 2012012 ENDING AT ('201201') ) ;
|
Partager