Problem with index

Поиск
Список
Период
Сортировка
Искать

Problem with index

От:
eriko <eriko@radix.com.br>
Дата:
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



Re: Problem with index

От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:

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 primary key.

FAQ