Hi,

>So if that left join takes 10s to execute it will be executed anyway
>even if there is no point to do that?

If there's no point, why are you inlcuding it on the SQL?


Regards,
Anderson Farias


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> Hi,
>
> > if there is a query:
> >
> > select
> > table1.field1,
> > table1.field2
> > from
> > table1
> > left join table2 on table1.field3 = table2.field1
> >
> > No fields from table table2 is being used. Will firebird execute left
> > join table2?
>
> Of course.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,

Oracle &

> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>