View Vs Join

[Former Member]

Dear Experts,

What is the best way of improving the performance in a selection, VIEW(creating a DB View) or JOIN (Joining the DB Tables)?

Thanks,

Bala

[christian_wohlfahrt]

Hi folks,

I'm not sure, if views are (without doubt) always faster than joins - runtime depends much more on join and where-clause, usable indices and so one.

But if an DB-table is buffered, at least projection views should make buffer accesses - joins will always bypass buffers (at least, views are not excluded in online documentation of 'SELECT').

Best regards,

Christian