Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cursor Vs View

483760Jul 16 2007 — edited Jul 16 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2007
Added on Jul 16 2007
2 comments
544 views