Re: [HACKERS] [SQL] SQL Query Optimization

2002-04-18 Thread Tom Lane
Dav Coleman <[EMAIL PROTECTED]> writes: > But basically I haven't done any ANALYZE or EXPLAIN yet because of the > fact that the order -is- making a difference so it can't be executing > the same query inside the database engine. If you haven't ever done VACUUM ANALYZE then the planner is flying

Re: [HACKERS] [SQL] SQL Query Optimization

2002-04-18 Thread Dav Coleman
I'm sorry, I realized after posting this that it went to the wrong list, I resent it to pgsql-sql instead. But basically I haven't done any ANALYZE or EXPLAIN yet because of the fact that the order -is- making a difference so it can't be executing the same query inside the database engine. Given