On 12/15/20 8:17 AM, Yambu wrote:
> 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
The question as written is unanswerable.
- Why do you think it needs to be optimized?
- What is the table cardinality, and the query cardinality?
- What does EXPLAIN say?
- Have you run ANALYZE on table1?
Bottom line: Postgres *might* think that it is more efficient to scan the
whole table.
--
Angular momentum makes the world go 'round.