Problem with index

From: eriko <eriko(at)radix(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with index
Date: 2001-01-25 23:56:37
Message-ID: 3A70BD35.8761C21@radix.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-01-26 00:05:56 Re: timestamp calculations
Previous Message Steve Leibel 2001-01-25 23:14:58 timestamp calculations