Thread: some optimization?

select distinct on (code) id,code,active from objects \
where version<=2 and (process=17 or process=0) \
group by id,code,active,version \
order by code asc,active desc,version desc

I'm a bit green with Postgres. Is this query performant enough? Are
there things I can do to make it better (indexing, some other method?)
I have 'id' as the primary key and unique(code,version,active).

-- Ciprian Popovici <ciprian.popovici@integrare.ro>

Ciprian Popovici wrote:
> select distinct on (code) id,code,active from objects \
> where version<=2 and (process=17 or process=0) \
> group by id,code,active,version \
> order by code asc,active desc,version desc
>
> I'm a bit green with Postgres. Is this query performant enough? Are
> there things I can do to make it better (indexing, some other method?)
> I have 'id' as the primary key and unique(code,version,active).
the common optimization step should surely be indexing on all the fields
used in "where" constraint. everything else depends on the various
additional parametres.