(Bob Watkins) When you need to troubleshoot inefficient SQL, one of the most important diagnostics tools at your disposal is the output of the EXPLAIN PLAN command. Find out how Oracle’s DBMS_XPLAN functions can help you tune your SQL statements.
Other News
Methods for Transforming data to a XML file
(Lalitha Venkatasubramanian) This articles mentions different ways to tranform data to XML file.
MySQL, today’s contender
(Ian Gilfillan) In May 2003, I wrote an article entitled MySQL–Yesterday’s Toy, Tomorrow’s Contender. I followed it up a year later with MySQL, Still tomorrow’s contender? Two years have now passed, and, since it is May once again, I thought it is time to follow up and see where MySQL stands today.
FIX: A query may run more slowly against SQL Server 2000 post-SP3 hotfix build 8.00.0988 than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988
When you run a query against Microsoft SQL Server 2000 post-Service Pack 3 (SP3) hotfix build 8.00.0988, the query may run more slowly than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988.
Table Partitioning in DB2 Viper
(Chris Eaton) As you may be aware, there are several technologies in DB2 v8.2 (and prior releases) that allow you to break up your data into smaller “chunks” to enable greater parallelism for queries, allow for partition elimination in queries and in general help improve performance. For example, Mu
Examining SQL Server Trace Files
(graz) I spend a lot of my time reading through trace files. I’ve started writing a utility called ClearTrace to make this process easier. It summarizes the performance of stored procedures and SQL statements much like Read80Trace does. It has both a GUI and command line version and handes traces fo
Why Oracle Works the Way it Does (7) – The PGA
(Dratz) Last time, we discussed some of the shared memory components in Oracle. This time we’ll talk about Oracle’s private parts (hey! get your mind out of the gutter). Specifically, let’s talk about the Program Global Area (PGA).
A Developer’s Introduction to Microformats
(Phil Haack) When Bill Gates recently said at the MIX Conference, “We need microformats,” he indicated that microformats are here to stay. Microformats are expected to have increased significance on the web. But what exactly are microformats?
IBM DB2 Document Manager with IBM Records Manager Solution Guide
(Wei-Dong Zhu, Carlos A Cedillo, Irina Grijalba, Nicole Hughes, Romney Kernek, Lai-Fong Leung and Steve Studer) IBM DB2 Document Manager Version 8.3 is one of the newest members of the IBM Enterprise Content Management portfolio. Document Manager provides a secure and robust platform to manage the c
Merging data into single table from multiple tables (resultsets)
(Sanjay Gulati) This article shows how to reduce the number of trips to improve performance by merging data into single table from multiple tables (resultsets).