01 CREATE TABLE cdr_all_data
02 (
03 cdr_id CHAR(20) NOT NULL,
04 cdr_date DATETIME YEAR TO SECOND NOT NULL,
05 ...
06 ...
07 )
08 FRAGMENT BY EXPRESSION
09 cdr_date BETWEEN '2006-01-01 00:00:00' AND
'2006-01-01 23:59:59' IN cdr_dbs1,
10 cdr_date BETWEEN '2006-01-02 00:00:00' AND
'2006-01-02 23:59:59' IN cdr_dbs2,
11 cdr_date BETWEEN '2006-01-03 00:00:00' AND
'2006-01-03 23:59:59' IN cdr_dbs3,
12 ...
13 ...
14 cdr_date BETWEEN '2006-03-22 00:00:00' AND
'2006-03-22 23:59:59' IN cdr_dbs80';
15
16 CREATE INDEX ix_cdr_id on cdr_all_data(cdr_id);
Listing 1: Anlegen einer
fragmentierten Tabelle
046-049_informix_v3.indd 47 21.06.2006 23:50:04 Uhr