Sub SELECTS
Sub SELECTS
От:
"Waruna Geekiyanage" <waruna@nirmani.com>
Дата:
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?
Re: Sub SELECTS
От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:
On Wed, 25 Sep 2002, Waruna Geekiyanage wrote: > 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? It depends on what you're doing. The query and table schema would be useful.