skip to main content
Table functions : Support for SQL concepts on table functions
 

Support for SQL concepts on table functions

SQL concepts, such as Views, Joins, Unions, and so on, are supported on table functions. These concepts can be applied on table functions similar to the way they are applied to other SQL tables.
The standard index-related OpenAccess SDK engine APIs are used for optimizing the query execution on table functions.
Aliases must be used on table functions in the following format:
SELECT * from TF (‘A’,’B’) as Table_Function;