In Oracle there is a table structure that defines a temporary table for the current session. This structure is called a global temporary table. The global temporary table definition is visible to all the sessions created by the user, but the data is only visible to the session in which it was created.
When the session is closed, the data in the temporary table is deleted. As opposed to other databases (Teradata, DB2, SQL Server), Oracle's global temporary tables' definition is not temporary, it persists even after the session has ended. This means that the tables are not dropped after the user disconnects and the session is closed.
Global temporary tables allow indexing. Indexes created on temporary tables are temporary as well, and the data in the index persists as long as the data exists in the global temporary table. Also, they can only be created on the tables before any data is inserted into them.
It is a decision of the system administrator to choose between global temporary tables and unlogged tables (NOLOGGING option).
HOW TO ENABLE GLOBAL TEMPORARY TABLES:
Syntax:
CREATE GLOBAL TEMPORARY TABLE tablename (columns)
To enable GLOBAL TEMPORARY TABLES in Oracle, set the following Very Large Database (VLDB) properties under the 'Tables' folder:
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Important notes regarding this type of tables:
The SQL for a report with the previous settings looks like the following SQL:
Report: GLOBAL TEMP TABLES EXAMPLE
create GLOBAL TEMPORARY table ZZMD00 (
Quarter_Id NUMBER(10),
M1 NUMBER)
ON COMMIT PRESERVE ROWS
CREATE INDEX I_ZZMD00 ON ZZMD00 (Quarter_Id, M1)
insert into ZZMD00 select a11.Quarter_Id Quarter_Id,
sum(a11.TOT_DOLLAR_SALES) M1
from QTR_CATEGORY_SLS a11
where a11.Quarter_Id in (199702, 199703)
group by a11.Quarter_Id
ANALYZE TABLE ZZMD00 ESTIMATE STATISTICS SAMPLE 25 PERCENT
create GLOBAL TEMPORARY table ZZMD01 (
YEAR_ID NUMBER(38, 0),
M2 NUMBER)
ON COMMIT PRESERVE ROWS
CREATE INDEX I_ZZMD01 ON ZZMD01 (YEAR_ID, M2)
insert into ZZMD01
select a12.YEAR_ID YEAR_ID,
sum(a11.TOT_DOLLAR_SALES) M2
from QTR_CATEGORY_SLS a11,
LU_QUARTER a12
where a11.Quarter_Id = a12.Quarter_Id
and a11.Quarter_Id in (199702, 199703)
group by a12.YEAR_ID
ANALYZE TABLE ZZMD01 ESTIMATE STATISTICS SAMPLE 25 PERCENT
select distinct a11.YEAR_ID YEAR_ID,
pa1.Quarter_Id Quarter_Id,
a11.QUARTER_DESC QUARTER_DESC,
pa1.M1 M1,
pa2.M2 M2
from ZZMD00 pa1,
LU_QUARTER a11,
ZZMD01 pa2
where pa1.Quarter_Id = a11.Quarter_Id and
a11.YEAR_ID = pa2.YEAR_ID
2. HOW TO ENABLE UNLOGGED TABLES:
Syntax:
CREATE TABLE tablename NOLOGGING AS (select clause)
To enable unlogged tables in Oracle, set the following VLDB properties under the 'Tables' folder:
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. | Custom group that displays Top 10 Customers and Bottom 5 Items [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" />
<PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" />
<PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/>
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="0" />
<PROPERTY NAME="SupportsKerberos" VALUE="1"/>
</PROPERTYSET>
<PROPERTYSET NAME="System SQL Templates">
<PROPERTY NAME="CatalogCacheMode" VALUE="3" />
<PROPERTY NAME="CatalogRetrievalMode" VALUE="2" />
</PROPERTYSET>SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options. |
Important notes about unlogged tables:
The SQL for a report with the previous settings looks like the following SQL:
Report: UNLOGGED TABLES EXAMPLE
create table ZZMD00 nologging as
select a11.Quarter_Id Quarter_Id,
sum(a11.TOT_DOLLAR_SALES) M1
from QTR_CATEGORY_SLS a11
where a11.Quarter_Id in (199702, 199703)
group by a11.Quarter_Id
ANALYZE TABLE ZZMD00 ESTIMATE STATISTICS SAMPLE 25 PERCENT
create table ZZMD01 nologging as
select a12.YEAR_ID YEAR_ID,
sum(a11.TOT_DOLLAR_SALES) M2
from QTR_CATEGORY_SLS a11,
LU_QUARTER a12
where a11.Quarter_Id = a12.Quarter_Id
and a11.Quarter_Id in (199702, 199703)
group by a12.YEAR_ID
ANALYZE TABLE ZZMD01 ESTIMATE STATISTICS SAMPLE 25 PERCENT
select distinct a11.YEAR_ID YEAR_ID,
pa1.Quarter_Id Quarter_Id,
a11.QUARTER_DESC QUARTER_DESC,
pa1.M1 M1,
pa2.M2 M2
from ZZMD00 pa1,
LU_QUARTER a11,
ZZMD01 pa2
where pa1.Quarter_Id = a11.Quarter_Id and
a11.YEAR_ID = pa2.YEAR_ID
drop table ZZMD00
drop table ZZMD01
