Oracle View Index
In this post , We will discuss that , whether we can create Index for Oracle View or not. We all know that We create Oracle View based on the Sql query. This query works independently and extract the dat for the Oracle View but some times we often find the issue of Performance in the Oracle Views but the limitation is that , we cannot create index on these oracle view. Either we can create index on the Tables used in the sql of the Oracle view based on the joins uses in this sql query and the second way is the materialized view in oracle. We can create the Index on Oracle Materialized view but not in the oracle simple view. Oracle view index is not feasible because views are just an sql query but we can create the materialized view and then apply oracle view index on this but materialized view has its own limitation , we cannot see the live date in the materialized view. Every time we need to refresh the materialized view to see the updated Data.
Oracle View Index
3 comments:
Your website have a valuable information,thanks for sharing information.
Oracle Financials Training in Ameerpet, Hyderabad
I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging.Oracle R12 Financials Training in Bangalore
This blog very easily understandable. Thanks for sharing such an informative post with us. This is a nice post in an interesting line of content.
Best Oracle Workflow Course in Bangalore
Post a Comment