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!

Do views cause queries to ignore indexes?

callen2Oct 31 2016 — edited Nov 7 2016

Greetings,

Oracle 12C: A co-worker is against the use of views because he says they cause the indexes on the underlying tables to be ignored, hurting query performance. This is the first I've heard of such a thing. Is it true? Is there a work-around?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2016

Added on Oct 31 2016

17 comments

2,356 views