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!

Is select from view faster then select from table..???

729689Jul 26 2010 — edited Jul 27 2010
Hello Gurus,

I want to query some data from two tables, both of table have many columns (attributes) and many rows...

I use several where clauses to retrieve data from those tables..


witch one is faster, I create a view or I just "select" from those tables???




Regards.

Nia...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2010
Added on Jul 26 2010
14 comments
12,241 views