SQL & PL/SQL

Hi,

I have two scenario.please let me know,which is better and why?

Scenario 1:

Cursor c1
Select * from view_table1_table2; (View)


Scenario 2:

Cursor c1:
replacing above view with actual select statement used to create view_table1_table2

Note: table1 and table2 used to create view_table1_table2,where each table contains millions of record.

Which scenario is good with respect to performance? and why?


Thanks
Aravindh