Обсуждение: Help with performance - No2

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

Help with performance - No2

От
Uros Gruber
Дата:
Hi!

This is second mail, I send it to quickly


NOTICE:  QUERY PLAN:

Nested Loop  (cost=0.00..154844.08 rows=96 width=36)
  ->  Seq Scan on table1 d  (cost=0.00..2957.36 rows=25236 width=28)
  ->  Index Scan using table1_pk on table2 c  (cost=0.00..6.00 rows=1 width=8)

I see that there is seq scan over 25k rows, how can i set
indexes to make query faster and use indexes.


--
TIA,
 Uros