Обсуждение: Problem with index

Hello all, I have a problem.

When a try to use EXPLAIN <select * from table where pk=value>

The optimize don't user the index of primary key.

Why ?

Thanks

Eriko

Have you run a vacuum analyze on the table in question?
How many rows does the optimizer think the query is going to
get (from the explain output)?

On Thu, 25 Jan 2001, eriko wrote:

> Hello all, I have a problem.
>
> When a try to use EXPLAIN <select * from table where pk=value>
>
> The optimize don't user the index of primary key.