Subject Re: [firebird-support] VIEWs and JOINs
Author Arno Brinkman

> 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
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.

Arno Brinkman

Firebird links :

Nederlandse firebird nieuwsgroep :