(Alexander Kuznetsov) When an index contains all the columns involved in a query, we usually say that an index covers a query. Whenever, this happens, the DB2 optimizer usually chooses to access only that index to satisfy a query, which is called index-only access or index covering. “Usually” does n
Other News
How to publish an XML Web service to an internal UDDI server by using Visual C# .NET 2003
To publish an XML Web service to an internal UDDI server by using Microsoft Visual C# .NET 2003, you must use the features that are implemented in the Microsoft.Uddi.dll assembly. This assembly is included with the Microsoft Platform Software Development Kit (SDK).
Serialize Arrays and ArrayLists to XML
(Dan Wahlin) The XmlSerializer class provides a great way to convert (serialize) objects to XML and back (deserialize). However, it can be difficult to serialize collections such as Arrays and ArrayLists properly unless you know a few tricks.
Using Oracle’s SQL Functions – Part 2
(Steve Callan) In this second article about SQL functions, we will look at 11 SQL-related functions commonly used in statistics: count, sum, average, standard deviation, variance and covariance (standard deviation and variance have three each; covariance has two).
Moving data from Oracle Forms to Microsoft Excel
(Carol Francum) The following is a sample trigger for using DDE to access an MS Excel spreadsheet. (R)
Leveraging XML Knowledge to Design, Develop, and Deploy Speech Applications
(Michael Polcyn) The voice solutions market is fueled by the rapidly growing number of consumers who want easy anytime, anywhere access to information and services via any device – wireline or wireless. With more than 1.5 billion phones and over 800 million mobile device users and 1 billion landline
MDX Essentials: Basic Numeric Functions: The Count() Function
(William Pearson) In this lesson, we will extend our attention from the purely set-related functions upon which we have concentrated in the last several articles; we will focus on a numerical function, Count(), specifically as it is applied to sets. We will discuss the straightforward purpose of the
23 Business Intelligence Tips
You can improve OLAP performance when you set a cube’s aggregation level. When you build a cube, you set the aggregation level according to the desired speedup in processing queries. (Speedup describes how much faster queries run with precreated aggregations than without aggregations.) The system es
Basic DB2 UDB Performance Tuning, Part 3
(Roger Sanders) In my previous columns, I showed how certain registry variables and configuration parameters influence the performance of DB2 Universal Database (UDB) for Linux, Unix, and Windows. In this column, I’ll tackle another factor that can have a significant impact on database performance:
DB2 interview questions
This article provides some great questions (and the associated answers) that you can ask of potential hires during the interview process.