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

2024 ODTUG Board Nominations - Guidelines

Board Nomination: Candidate Example