#!/bin/sh

./run_tool.sh<<EOF
open db salesdemo;
CREATE INDEX index_item_name ON item (
    item_name 
);

CREATE INDEX index_cust_post_phone_no ON customer (
    post_no ,
    phone_no 
);

CREATE UNIQUE INDEX  index_dwpt_name ON employee (
    dept_name
);

CREATE INDEX index_ent_date ON  salesorder (
    ent_date 
);

CREATE INDEX index_sum ON  salesordertail (
    sum 
);
close db ;
EOF
