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
Introducing the Newest Members of the ODTUG 2024 Board of Directors

2024 ODTUG Board Nominations - Guidelines

Board Nomination: Candidate Example