In this article, we will describe the most popular methods that DW engineers use today to solve SQL performance problems, based on our real-world experience. We will point out the pros and cons of each method, as well as describe the basic tools/commands for using each one, and provide some best-practice recommendations. The intended audience is DW support engineers, DW developers, and DBAs. The methods presented are not DW-specific and pertain to SQL tuning in general, so this article will be useful to a broader audience of database professionals with interest in SQL tuning and not only to Data Warehouse professionals..
Natalie Delemar has been a volunteer with ODTUG since 2008, holding variousroles such as Hyperion SIG secretary, EPM/BI content chair, and ODTUG Kscopeconference chair. She recently completed a four-y...
Congratulations to the newly elected members of the 2020-2021 ODTUG Board of Directors. The new board will be seated January, 1, 2020. Thank you to everyone who voted and to all the nominees who parti...
2601 Iron Gate Drive, Suite 101
Wilmington, NC 28412