HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 40

Appendix C DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers AND L_ORDERKEY = O_ORDERKEY AND O_CUSTKEY = C_CUSTKEY AND C_NATIONKEY = N1.N_NATIONKEY AND N1.N_REGIONKEY = R_REGIONKEY Query 8 - Variant B (Con't.) AND R_NAME = 'AMERICA' AND S_NATIONKEY = N2.N_NATIONKEY AND O_ORDERDATE BETWEEN TO_DATE ('1995-01-01','YYYY-MM-DD') AND TO_DATE('1996-12-31','YYYY-MM-DD') AND P_TYPE = 'SMALL BRUSHED STEEL' ) ALL_NATIONS GROUP BY YEAR ORDER BY YEAR; Query 9 - Original SELECT NATION, YEAR, SUM(AMOUNT) AS SUM_PROFIT FROM (SELECT N_NAME AS NATION, TO_CHAR(O_ORDERDATE,'YYYY') AS YEAR, L_EXTENDEDPRICE * (1-L_DISCOUNT) - PS_SUPPLYCOST * L_QUANTITY AS AMOUNT FROM PARTS, SUPPLIER, LINEITEM, PARTSUPP, ORDERS, NATION WHERE S_SUPPKEY = L_SUPPKEY AND PS_SUPPKEY = L_SUPPKEY AND PS_PARTKEY = L_PARTKEY AND P_PARTKEY = L_PARTKEY AND O_ORDERKEY = L_ORDERKEY AND S_NATIONKEY = N_NATIONKEY AND P_NAME LIKE '%wheat%' ) PROFIT GROUP BY NATION, YEAR ORDER BY NATION, YEAR DESC; Query 10 - Original set_fetchrows=20; SELECT C_CUSTKEY, C_NAME, SUM(L_EXTENDEDPRICE * (1-L_DISCOUNT)) AS REVENUE, C_ACCTBAL, N_NAME, C_ADDRESS, C_PHONE, C_COMMENT FROM CUSTOMER, ORDERS, LINEITEM, NATION WHERE C_CUSTKEY = O_CUSTKEY AND L_ORDERKEY = O_ORDERKEY AND O_ORDERDATE >= TO_DATE('1995-01-01' ,'YYYY-MM-DD') © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398