Compaq ProLiant 6500 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq - Page 30

Appendix A DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers CUSTOMER Table Layout Column Name C_CUSTKEY C_NAME C_ADDRESS C_NATIONKEY Datatype Requirements identifier variable text, size 25 variable text, size 40 identifier C_PHONE fixed text, size 15 C_ACCTBAL decimal C_MKTSEGMENT fixed text, size 10 C_COMMENT variable text, size 117 Primary Key: C_CUSTKEY ORDER Table Layout Column Name O_ORDERKEY Datatype Requirements identifier O_CUSTKEY identifier O_ORDERSTATUS fixed text, size 1 O_TOTALPRICE decimal O_ORDERDATE date O_ORDERPRIORITY fixed text, size 15 O_CLERK fixed text, size 15 O_SHIPPRIORITY integer O_COMMENT variable text, size 79 Primary Key: O_ORDERKEY Comment SF*150,000 are populated Foreign key reference to N_NATIONKEY Comment SF*1,500,000 are sparsely populated Foreign key reference to C_CUSTKEY © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398