Re: [ADMIN] Problem with index

2001-01-25 Thread Stephan Szabo
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 > > The optimize don't user the index of primar

[ADMIN] Problem with index

2001-01-25 Thread eriko
Hello all, I have a problem. When a try to use EXPLAIN The optimize don't user the index of primary key. Why ? Thanks Eriko