From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Thomas Good <tomg(at)nrnet(dot)org> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] slow queries |
Date: | 1998-09-18 15:19:20 |
Message-ID: | 199809181519.QAA14702@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thomas Good wrote:
>I have a query that looks up a patient's placement (which ward)
>in one table and then looks up diagnostic and demographic data
>in another...takes 53 seconds. Ouch.
>
>However, when I use table aliasing...the query output is on the
>screen *before* I submit the query. ;-)
>
>I'll send syntax, if you like.
Please do, to the list. I have never heard of 'table aliasing' and would
like to know more.
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Give, and it shall be given unto you; good measure,
pressed down, and shaken together, and running over,
shall men pour into your lap. For by your standard of
measure it will be measured to in return."
Luke 6:38
From | Date | Subject | |
---|---|---|---|
Next Message | Anand Surelia | 1998-09-18 15:32:19 | Foreign Key |
Previous Message | David Hartwig | 1998-09-18 14:37:49 | Re: [GENERAL] slow queries |