| CREATE TABLE trafodion.sales.odetail |
| ( ordernum NUMERIC (6) UNSIGNED NO DEFAULT NOT NULL |
| , partnum NUMERIC (4) UNSIGNED NO DEFAULT NOT NULL |
| , unit_price NUMERIC (8, 2) NO DEFAULT NOT NULL |
| , qty_ordered NUMERIC (5) UNSIGNED NO DEFAULT NOT NULL |
| , PRIMARY KEY ( ordernum, partnum ) |
| ) ; |
| |
| INSERT INTO trafodion.sales.odetail VALUES |
| ( 100210, 244, 3500.00, 3 ) |
| , ( 100210, 2001, 1100.00, 3 ) |
| , ( 100210, 2403, 620.00, 6 ) |
| , ( 100210, 5100, 150.00, 10 ) |
| , ( 100250, 244, 3500.00, 4 ) |
| , ( 100250, 5103, 400.00, 10 ) |
| , ( 100250, 6301, 245.00, 15 ) |
| , ( 100250, 6500, 95.00, 10 ) |
| , ( 101220, 255, 3900.00, 10 ) |
| , ( 101220, 5103, 400.00, 3 ) |
| , ( 101220, 7102, 275.00, 7 ) |
| , ( 101220, 7301, 425.00, 8 ) |
| , ( 200300, 244, 3500.00, 8 ) |
| , ( 200300, 2001, 1000.00, 10 ) |
| , ( 200300, 2002, 1400.00, 10 ) |
| , ( 200320, 5504, 165.00, 5 ) |
| , ( 200320, 6201, 195.00, 16 ) |
| , ( 200320, 6301, 245.00, 6 ) |
| , ( 200320, 6400, 540.00, 7 ) |
| , ( 200490, 3210, 715.00, 1 ) |
| , ( 200490, 5505, 350.00, 1 ) |
| , ( 300350, 244, 2800.00, 20 ) |
| , ( 300350, 5100, 150.00, 5 ) |
| , ( 300350, 5110, 525.00, 12 ) |
| , ( 300350, 6301, 245.00, 5 ) |
| , ( 300350, 6400, 550.00, 5 ) |
| , ( 300380, 244, 3000.00, 6 ) |
| , ( 300380, 2402, 320.00, 12 ) |
| , ( 300380, 2405, 760.00, 8 ) |
| , ( 400410, 212, 2450.00, 12 ) |
| , ( 400410, 255, 3800.00, 12 ) |
| , ( 400410, 2001, 1000.00, 36 ) |
| , ( 400410, 6301, 240.00, 48 ) |
| , ( 400410, 6400, 500.00, 70 ) |
| , ( 400410, 7301, 415.00, 36 ) |
| , ( 500450, 212, 2500.00, 8 ) |
| , ( 500450, 255, 3900.00, 12 ) |
| , ( 500450, 2001, 1100.00, 16 ) |
| , ( 500450, 2002, 1500.00, 16 ) |
| , ( 500450, 2402, 330.00, 48 ) |
| , ( 600480, 2001, 1000.00, 60 ) |
| , ( 600480, 2002, 1450.00, 20 ) |
| , ( 600480, 2003, 1900.00, 40 ) |
| , ( 600480, 3103, 4000.00, 40 ) |
| , ( 600480, 3205, 625.00, 20 ) |
| , ( 600480, 5100, 135.00, 60 ) |
| , ( 600480, 5103, 390.00, 20 ) |
| , ( 600480, 7301, 425.00, 40 ) |
| , ( 700410, 2003, 1900.00, 65 ) |
| , ( 700410, 2403, 650.00, 10 ) |
| , ( 700510, 255, 4000.00, 4 ) |
| , ( 700510, 6500, 95.00, 8 ) |
| , ( 700510, 7102, 275.00, 5 ) |
| , ( 800660, 244, 3000.00, 6 ) |
| , ( 800660, 2001, 1000.00, 30 ) |
| , ( 800660, 2403, 600.00, 48 ) |
| , ( 800660, 2405, 795.00, 10 ) |
| , ( 800660, 3201, 525.00, 6 ) |
| , ( 800660, 3205, 600.00, 18 ) |
| , ( 800660, 3210, 715.00, 6 ) |
| , ( 800660, 4102, 26.00, 130 ) |
| , ( 800660, 5100, 150.00, 12 ) |
| , ( 800660, 5101, 200.00, 6 ) |
| , ( 800660, 5110, 490.00, 48 ) |
| , ( 800660, 5504, 165.00, 18 ) |
| , ( 800660, 6201, 195.00, 6 ) |
| , ( 800660, 6301, 235.00, 24 ) |
| , ( 800660, 6400, 525.00, 30 ) |
| , ( 800660, 6401, 700.00, 36 ) |
| , ( 800660, 6500, 95.00, 22 ) |
| , ( 800660, 7102, 275.00, 6 ) |
| , ( 800660, 7301, 425.00, 12 ) |
| ; |
| |
| UPDATE STATISTICS FOR TABLE trafodion.sales.odetail ON EVERY COLUMN ; |