Orest Kozyar wrote:
What I am wondering is whether the database first eliminate all rows in
tableA that don't meet the criteria before performing the join, or does it
perform the join first then eliminate all records that don't meet the
criteria?
If you use "EXPLAIN SELECT ..." then PostgreSQL
I have the following sql:
CREATE OR REPLACE FUNCTION foo (in x integer) RETURNS float AS $$
SELECT max(tableB.columnC)
FROM
tableA inner join tableB on (tableA.columnA =
tableB.columnB)
WHERE
tableA.columbA = x
... (additional code to select
