Re: indexes and big tables

> The index is only used for the line= part of the where clause
> with your query. With many rows the "line=" is not selective enough
> to justify the index.

Hi, I tried you suggestion about 'AND counterstamp > '2001-07-26 00:00:00.0' and
it works and index is used :) But, whole query run for 10 sec (was 30s) and
it's too much, I need about 1 sec. May I optimize my tables, queries or may I
upgrade something from my HW (duron 700, 384MB RAM, slow scsi disk :( )? I
do not want solution, some hint in which part may I focus and I will go through
documentation again, thank you very much.

Best regards, Robert

--   _ |-|  __      Robert Vojta <vojta-at-ipex.cz>          -= Oo.oO =- |=| [Ll]     IPEX, s.r.o. "^" ====`o