Re: [SQL] Question about Sql SELECT and optimizer

2006-03-02 Thread Michael Fuhr
On Thu, Mar 02, 2006 at 11:19:32AM -0500, Chaz. wrote: > I am trying to understand something I have seen happen. I had a select > that looked like: > > select f(A) from A, B, C where g(A) > > Where f(A) is the select that only depends on table A; > g(A) is the where part that only depends on tabl

[SQL] Question about Sql SELECT and optimizer

2006-03-02 Thread Chaz.
I am trying to understand something I have seen happen. I had a select that looked like: select f(A) from A, B, C where g(A) Where f(A) is the select that only depends on table A; g(A) is the where part that only depends on table A. What I saw happen was the optimizer will waste a lot of time (s