New Technical Journal Article Now Available

SQL Tuning for Day-to-Day Data Warehouse Support
Nikos Karagiannidis, oradwstories.blogspot.com

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..

Read more here.

You must be a member of ODTUG to access Technical Journal articles. There are three membership options, including a free Associate Membership. Join now.

Recent Stories
ODTUG 2020 Leadership Program Application Now Open

ODTUG July 2019 Newsletter

2020 Leadership Program - Now Accepting Applications