You can translate the question and the replies:

Do we need to generate the statistics for Interface views

Generating statistics for base view is enough or generating statistic for interface views will also improve performance
Generate stats interface view VDP query optimisation
user
02-12-2016 06:31:04 -0500
code

1 Answer

Hi, I would like to first clarify about interface views in Denodo. They are basically a special type of view to do top-down design which consists of definition of fields and a reference to another view. Where you can first define the fields of the interface and at a later stage you will be able to associate to a "implementation view" of the interface. Therefore a query that involves a interface is always delegated to the implementation view. So when you would like to improve the performance of an interface view then you need to neccesiarly generate the statistics for the implementation view. Hope this helps!
Denodo Team
07-12-2016 05:41:51 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here