Optimize query

From: Yambu <hyambu(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Optimize query
Date: 2020-12-15 14:17:52
Message-ID: CALhHtcDZ0WWNW_-p58S7eBQB97XHdXuwC9jkxK5a03ODbe9GGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raul Giucich 2020-12-15 14:27:59 Re: Optimize query
Previous Message Joel Mariadasan (jomariad) 2020-12-15 10:44:07 pg_ctl.exe deleted on abrupt shutdown of Windows