Re: help with query speed

Hi

> > I have the below query written. I have removed a lot from the
select
> > Statement for simplicity sake. The query takes way too long.
> > I am moving from an Access backend to a Postgres back with
> > Access in the front. The below query is taking like 14-20 seconds.
> > Is their a better way I can write the joins. I would think that
> > Postgres should be fast than Access. BTW I am writing these as
> > Pass through queries so it is not a problem with Access. I
> > have Even ran the query directly against Postgres.
> >
> > SELECT
> > tblroster.transcriptlink
> > FROM
> > tblroster
> > FULL OUTER JOIN testclass ON (tblroster.classlink =
> > testclass.classid)
> > FULL OUTER JOIN tblqualitypoint ON (tblroster.lettergrade =
> > tblqualitypoint.letter)
> > ORDER BY
> > tblroster.transcriptlink
>
> Is there an index on:
> tblroster.classlink
>
> Is there an index on:
> testclass.classid
>
> Is there an index on:
> tblroster.lettergrade
>
> Is there an index on:
> tblqualitypoint.letter
>
> Is there an index on:
> tblroster.transcriptlink

I created the indexes and it speed up a little. Still a little slower
than
Access though. Which I think should not be. The testclass is a view
not
A query so I cannot make an index there.

What is the best way to index this stuff? Should I make one index
(b-tree)
And add all fkeys and pkey from that table?

> How many rows are in the tables?