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..
You must be a member of ODTUG to access Technical Journal articles. There are three membership options, including a free Associate Membership. Join now.