1 2 3 4 5 6 7 8
CREATE DATABASE numismatics; /*+ CACHESIZE = 16m */ CREATE TABLE coin (cid INT(8) PRIMARY KEY, unit VARCHAR(20)); CREATE INDEX ON coin(unit);