Usage Of View

[krishd]

Using the view in the query will improve the Performance??

View is directly from one or more tables no complex logic.

[frozenmist]

Hi Krish,
Using a view doesnt improve the performance.
During runtime what oracle does is, it uses the view query inside the current query.

EG:
If view is like
create view myview as
select * from emp where dept=10;

If your query is
select * from myview where enum=1234;

Then the query which oracle will be running is

select * from emp where dept=10 and enum=1234;


Cheers