skip to main content
OpenAccess SDK Service Attributes : Defining Service Attributes : ServiceSQLViewToSubQueryTransform
 

ServiceSQLViewToSubQueryTransform

Controls how a view is executed. A view can be executed by re-writing the query to combine the query defining the view and the query specified by the user. This results in the most efficient processing of queries on views. The alternative is to process the view as a sub-query and then perform the user specified query on the results of the sub-query.

Valid values

*-1=The query is transformed when possible. This is the recommended setting.
*0=The query is never transformed.
*1=The query is always transformed.

Default

-1

Type

Static

IP Type

All