You can translate the question and the replies:

I need to force index in a integration view with out edit base view from query

Hi, can us help me with that? i want to know if is possible to "force use index" in a oracle sql db by a integration view. /*+ INDEX(bd.table IDX_EXAMPLE) */ Thanks,
user
25-04-2023 13:05:21 -0400
code

1 Answer

Hi, An index of a base view is automatically propagated to its derived views. However there are exceptions to that. When your derived view is a flatten view or union view, the index is not propageted. Also when your derived view includes a GROUP BY statement, only the indexes whose fields are in the GROUP BY clause are propagated. When creating a base view using the JDBC driver, you don't need to define your indexes as they are automatically imported from the data source. In any other case, you have to manually define the index in the base view. Note that defining an index in your base view does not create the index in the data source itself though there are three exceptions: 1. Remote tables 2. Summaries 3. Cached views To summarize: if you have an index in your oracle data base to which you connect via the JDBC driver, any base views you create will include your index. Your derived views might also have these indexes included, depending on the type of derived views. You can find more information about indexes in Denodo and how to create them in the [Indexes of Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/advanced_configuration_of_views/indexes_of_views) Section of the Virtual Dataport Administration Guide. I hope this answer helps!
Denodo Team
26-04-2023 08:58:40 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here