here are the details:

CREATE TABLE DATA (
STOCK VARCHAR(55),
SYMBOL VARCHAR(8),
DATA DATE,
OPN FLOAT,
HIGH FLOAT,
LOW FLOAT,
CLS FLOAT,
VOL FLOAT);

/* Indices */

CREATE INDEX DATA_1DX1
ON DATA(STOCK);
CREATE INDEX DATA_IDX2
ON DATA(SYMBOL);
CREATE INDEX DATA_IDX3
ON DATA(DATA);


Total records: 800,000 rows, 8 fields.

exact query: SELECT STOCK FROM DATA GROUP BY STOCK ORDER BY STOCK

pc spec: p4 2.4, 512 mb

I appreciate the help. Thanks.