New Technical Journal Article Now Available

SQL Tuning for Day-to-Day Data Warehouse Support
Nikos Karagiannidis,

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
Announcing the 2022 ODTUG Board of Directors
ODTUG Kscope21 Virtual Event Presentations and Recordings Now Available to Full Members

Join the 2022 ODTUG Board of Directors - Call for Nominations Now Open