Re: help with query speed

> -----Original Message-----
> From: Jason Tesser [mailto:JTesser@nbbc.edu]
> Sent: Thursday, February 12, 2004 10:03 AM
> To: pgsql-general@postgresql.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?