Re: Seq Scan
От | Dave Cramer |
---|---|
Тема | Re: Seq Scan |
Дата | |
Msg-id | 029801c0e798$cd8c1990$230470d1@INSPIRON обсуждение исходный текст |
Ответ на | Seq Scan (Linh Luong <linh.luong@computalog.com>) |
Список | pgsql-general |
Can you send the relevant tables, indexes, and query --dc-- ----- Original Message ----- From: "Linh Luong" <linh.luong@computalog.com> To: <pgsql-general@postgresql.org> Sent: Monday, May 28, 2001 12:23 PM Subject: [GENERAL] Seq Scan > Hi, > > I am trying to execute this query I wrote and it is not returning at a > reasonable time to the browser. I took the query and ran EXPLAIN on it > and it displayed that every JOIN I do it is doing a Seq Scan on it. I > have indexes on that table but it doesn't seem to use it. > > Is there a way I can ensure that postgres will use my indexes? > > Thanks again > > > Linh > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-general по дате отправления: