Re: help with query speed

> -----Original Message-----
> From: Jason Tesser [mailto:JTesser(at)nbbc(dot)edu]
> Sent: Thursday, February 12, 2004 10:03 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] help with query speed
>
>
> 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

How many rows are in the tables?