--- In firebird-support@yahoogroups.com, "menjit_singh"
<menjit_singh@y...> wrote:

>
> 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.
>

There's nothing to group,
Caching does not slow the first query, it speeds the second.
There's no primary key - don't know if that would have any speed effect
Interesting that you have a field with the same name as the table -
maybe it could become datum :)

Mick