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!

Does a view uses the indexes ?

pmohananAug 12 2002

Hi..All,

I have created a view by joining 4 tables. The question I have is , will it use the indexes created on the under lying tables when I use view with some where clause?

TIA

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2002

Added on Aug 12 2002

15 comments

826 views