Subject VIEWs and JOINs
Author Anand
I have two questions, each on the use of VIEWs and JOINs, with
respect to the speed of retrieval or execution of query.

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?

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

Thanks in advance for the tips and suggestions,


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software