> I'm facing a wired problem. When I left join two tables PostgreSQL is
> able to do it fast using the corresponding indices, However, if I
> define a simple view (to format the data) on one of the tables, the
> left join does not use the indices. Is something wrong here?
At a guess, the complex CASE statements are causing the planner to behave
badly. What happens if you do a straight join and not a left join?
Also, it's generally a good idea to put your join expression in the same order
as the referenced tables. You confused me and you could confuse the planner
at some stage.
Aglio Database Solutions
In response to
pgsql-sql by date
|Next:||From: Olivier Hubaut||Date: 2004-04-01 07:07:52|
|Subject: Re: Is it normal that functions are so much faster than inline queries |
|Previous:||From: Josh Berkus||Date: 2004-03-31 22:41:22|
|Subject: Re: [SQL] SQL Spec Compliance Questions|