Supporting Your System Configuration

Different SQL standards among various database platform (DBMS) types require that some VLDB properties are initialized to different default settings depending on the DBMS used. For example, when using a Microsoft Access 2000 database, the Join Type VLDB property is set to Join 89. This type of initialization ensures that different DBMS types can be supported. These initializations are also used as the default VLDB settings for the respective DBMS type. To create and review a detailed list of all the default VLDB settings for different DBMS types, see Default VLDB Settings for Specific Data Sources.

VLDB properties also help you configure and optimize your system. You can use MicroStrategy for different types of data analysis on a variety of data warehouse implementations. VLDB properties offer different configurations to support or optimize your reporting and analysis requirements in the best way.

For example, you may find that enabling the Set Operator Optimization VLDB property provides a significant performance gain by utilizing set operators such as EXCEPT and INTERSECT in your SQL queries. On the other hand, this property must offer the option to be disabled, since not all DBMS types support these types of operators. VLDB properties offer you a choice in configuring your system.