Cursor Vs View
483760Jul 16 2007 — edited Jul 16 2007Hi,
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