usage of views

Hello,

Will the usage of a view to substitute for a query make it run any faster ? If so, why ?

For instance if I do a select

select a.1, a.2, b.3, b.4
from a, b
where a.1 = b.1
and a.2 = b.2;

Instead I define a view

create view xyz as select
a.1, a.2, b.2, b.3, b.4
from a, b
where a.1 = b.1;

and then do a select * from xyz where b.2 = 'some value';

Does the second scenario make it run any faster ? My contention is that it should be slower. Any views, pointers welcome.

TIA ajay Received on Tue Mar 14 2000 - 00:00:00 CST