Query speed

Поиск

Список

Период

Сортировка

От	RFLM101@aol.com
Тема	Query speed
Дата	4 января 2003 г. 09:18:01
Msg-id	e.2ad19487.2b484718@aol.com обсуждение исходный текст
Список	pgsql-general

Дерево обсуждения

I'm working on moving several medium size tables from Oracle to Postgres. The table I'm dealing with has 210000 rows. I've indexed the table with a simple single column index on a varchar(30) column that is unique but doesn't have a unique constraint placed on it.

When I issue a select* from table where column = part,
query speed is great, however, changing the where clause to "where column like 'part%'" the explain analyze shows the database doing a full table scan and not utilzing the index which slows the query speed.

Oracles optimizer, on the other hand, will use the index so that there is no comparison in terms of query speed...

How can I get Postgresql's optimizer to use the index?

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Query speed