Hi,

> What would be the advantage of using a VIEW over a set of
> tables? For e.g. if I were using a SELECT query on a JOIN
> between two tables, would there be any performance benefits if I
> put the JOIN on the tables into a VIEW and accessed the VIEW
> instead of the separate tables?

Performance should be the same, but in sometimes in FB1.0 the optimizer
doesn't.
Depending on how complex (INNER / OUTER JOINS) the view is.
Look at the resulting PLAN to see the result.

> Also what works faster in FireBird, an explicit JOIN or a JOIN
> enforced in the WHERE clause?

For an INNER JOIN should also be the same.


Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81