Re: Index Usage Question

From: Tanel Poder <tanel_at_@peldik.com>
Date: Tue, 24 Jun 2003 04:35:15 +0300
Message-ID: <3ef7aae4$1_1@news.estpak.ee>

Hi!

> When the query is executed for one or two ioid values , the proper index
is
> used. However when a third point is addes to the retrieval a full table
> scan is initiated (this is a problem as the table currently contains
> ~60,000,000 records). Ideally it would always (or nearly always) use the
> index.
>
> The index is unique on the ioid and reportdatentime columns of the table.

Have you recently analyzed your indexes and tables? What are the values for your parameters optimizer_index_cost_adj, optimizer_index_caching and db_file_multiblock_read_count ?

Tanel. Received on Mon Jun 23 2003 - 20:35:15 CDT