The Team

RDBMS BI Tuning Specialists
The Technical Advisory Services team is assembled with key consulting specialists with extensive RDBMS knowledge and specific BI experience with your DBMS environment.

MicroStrategy Technical Advisory Services Team

Product
Specialist

RDBMS BI
Tuning Specialist

Enterprise App.
Specialist

Industry
Specialist

RDBMS BI Tuning Specialist Capabilities
Sybase	Informix	SQL Server	Tandem
Oracle	DB2 UDB	Teradata	General
Creation of most advantageous Oracle Hints to ensure the optimizer is tuned appropriately for the MSTR application Strategies to leverage Oracle 9i Real Application Clusters (RAC) to increase fault tolerance of complete clusters Materialized view optimizations Query plan analysis	AST (Automatic summary Table) creation for optimal functionality with Engine’s aggregate table navigation Common table vs. temporary table analysis Reduce physical page requests, locks and commits Query optimization on AS/400 using encoded vector indices Partition key analysis for optimal join processing	Optimal primary index selection and creation to ensure best data distribution and join performance for the Teradata MPP architecture Join index analysis Derived table vs. temporary table analysis Reduce physical page requests, locks and commits Leveraging CLI-API to take advantage innate Teradata capabilities	Database indexing Explain plan analysis for optimal SQL tuning Aggregate table creation based on query and usage pattern analysis Join analysis Concurrency and locking control Database analytics vs. MicroStrategy analytics

MicroStrategy, a global leader in business intelligence technology, provides integrated reporting, analysis, and monitoring software that helps leading organizations make better business decisions every day. Find out more about us.

Copyright © 2008 MicroStrategy, Inc. All Rights Reserved.
Careers | Privacy Statement | Legal Notices & Terms of Use | Contact Us | Site Map | MicroStrategy EthicsLine
1861 International Drive, McLean, Virginia 22102. Tel: 866.966.MSTR Tel: 703.848.8600 Fax: 703.848.8610

MicroStrategy Business Intelligence Services