Re: [SQL] Good Optimization

From: "Roderick A(dot) Anderson" <raanders(at)altoplanos(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PG-SQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] Good Optimization
Date: 1999-07-07 16:10:13
Message-ID: Pine.LNX.4.04.9907070908570.14628-100000@asgard.altoplanos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, 7 Jul 1999, Tom Lane wrote:

> The Postgres optimizer doesn't care about the order of where clauses;
> it'll pick out the clauses it thinks are most effective regardless
> of the order you write them in.
>
> regards, tom lane

As I figured it would be as soon as I opened my big mouth.

Rod
--
Roderick A. Anderson
raanders(at)altoplanos(dot)net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-07-07 16:45:07 Re: [SQL] Good Optimization
Previous Message Tom Lane 1999-07-07 15:44:58 Re: [SQL] Good Optimization