Re: Optimize query

Hi Yambu, the btree index type is optimized for this kind of operators (>,
>=, <, <=, =).
For deep understanding on how to plan an query optimization I would
recommend https://classroom.google.com/c/MTQ4MzczNDExMjM4 and
https://use-the-index-luke.com.
Another tip is use in the select clause only the columns that are
significant to answer the question you user is making executing this query.
Sorry for my foreign english.
Best regards.
Raúl.

El mar, 15 dic 2020 a las 11:18, Yambu (<hyambu(at)gmail(dot)com>) escribió:

> 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
>