You can translate the question and the replies:

Primary Key Must?

Hello, Does Denodo require primary key on all views even if it is not defined on source system? If yes, Why? What benefits it offer. Thanks, Adinath
user
19-04-2018 05:40:21 -0400
code

1 Answer

Hi, In Denodo Platform, if a view is imported through a JDBC or ODBC data source then its defined primary keys are imported. Virtual DataPort does not force the primary key definitions, so even if the primary key for a view is not defined in the source system it can be created as views in Virtual DataPort. But it is a good practice to define primary keys in views to utilize the following benefits * Denodo applies "aggregation pushdown" optimization which can avoid movements of large data through a network and by which execution time for views can be reduced. In order to utilize this technique, primary key information for a view is required. * Some functionalities in web applications like Self-service tool and RESTful web service needs primary key to be defined. * Primary key information of a view is exposed to consuming applications which will be a more efficient. Have a look at the section [Primary Keys of Views](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/restful_architecture/primary_keys_of_views/primary_keys_of_views#primary-keys-of-views) of the Virtual DataPort Administration Guide for more information. Hope this helps.
Denodo Team
20-04-2018 03:34:45 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here