Home > mailing lists

Optimize query - Mailing list pgsql-general

From	Yambu
Subject	Optimize query
Date	December 15, 2020 17:17:52
Msg-id	CALhHtcDZ0WWNW_-p58S7eBQB97XHdXuwC9jkxK5a03ODbe9GGA@mail.gmail.com Whole thread Raw
Responses	Re: Optimize query Re: Optimize query
List	pgsql-general

How would you optimize a query with greater than in where clause eg

select * from table1 where id > 1000

and there is an index on id column

regards

From: "Joel Mariadasan (jomariad)"
Date: 15 December 2020, 13:44:07
Subject: pg_ctl.exe deleted on abrupt shutdown of Windows

From: Raul Giucich
Date: 15 December 2020, 17:27:59
Subject: Re: Optimize query