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 (seconds!)
bringing in table B and C. I was wondering why doesn't the optimizer
drop references to tables B and C since they aren't used any where?
Peace and thanks in advance
Chuck Wegrzyn
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
