Sub SELECTS

From: "Waruna Geekiyanage" <waruna(at)nirmani(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Sub SELECTS
Date: 2002-09-25 14:27:11
Message-ID: 003701c2649f$a5f6fc80$705e5ecb@A.GEEKIYANAGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a select query with 2 sub selects.
When I run that query CPU usage goes to 98% for postgres.
Does sub selects eat more resources and slower the queries?
Is there any alternatives to sub selects?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2002-09-25 14:34:47 removing fields
Previous Message Devinder K Rajput 2002-09-25 14:14:36 logging