Re: What constitutes a complex query

On May 6, 2008, at 8:45 AM, Justin wrote:

> This falls under the stupid question and i'm just curious what other  
> people think what makes a query complex?

If I know in advance exactly how the planner will plan the query (and  
be right), it's a simple query.

Otherwise it's a complex query.

As I get a better feel for the planner, some queries that used to be  
complex become simple. :)

Cheers,
   Steve


-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance