instantOLAP Online documentation 2.2.7 - Table Order

Table Order

Type

Constant String

Since

2.2

Description

This property is for optimizing issues only. When generating SQL-statements, the SQL-generator will use this optional property to define the order of the tables in the FROM-clause of the generated SELECT statement.

In some databases, the order of the tables in the statements can have a big effect on the performance because the order influences the used indices.

Examples

Table Order = "Products,Customers,Productgroups"

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Query properties
Chart properties
Configuration properties
Configuration
Database
Table
Column
Alias
Link
Link-Expression
Table-Expression
CSV-Source
CSV-Column
XMLA-Source
Dimension
Grant
Key
Key-Attribute
SQL-Keyloader
SQL-Attribute
CSV-Keyloader
CSV-Attribute
Time-Keyloader
Time-Attribute
XMLA-Keyloader
XMLA-Attribute
Number-Keyloader
SQL-Cube
Active
Build Timeout
Cron Pattern
Database
Distinct
Enable Load
Enable Offline Mode
Enable Store
Line Dimension
Match
Match Mode
Match Roots
Name
SQL-Order
SQL-Order Descending
SQL-Where
Table Order
SQL-Fact
SQL-Dimension
CSV-Cube
CSV-Fact
CSV-Dimension
XMLA-Cube
XMLA-Fact
XMLA-Dimension
Formula
File-Cache
File-Store
Include
Expressions
Formats
SQL-Expressions