This paper provides an initial look at indexing and statistics strategies and their effects on query performance. It provides basic information about indexes in DB2 UDB for iSeries, the data structures underlying them, and how the server uses them. It also discusses additional indexing considerations related to maintenance, tools, and methods.
Did you find this white paper useful?
13 out of 25 users found this white paper useful
Related white papers
Protecting virtual macchines: the "best of Vmworld" approach
By enabling IT managers to move virtual machines (and the applications they host) between physical servers, server virtualization gives them a powerful method for reducing planned downtime and speeding recovery....
Green IT: Reducing your Carbon Footprint with Citrix
Going green has become an imperative, not an option, for companies facing the new reality of balancing business objectives with dwindling environmental resources. Limited energy supply and skyrocketing costs are...
Security Beyond Corporate Boundaries: Using Citrix Application Delivery to Protect Corporate Information Anywhere Business Happens
Ironclad security has become the Holy Grail for companies looking to protect corporate and customer information at large in the modern enterprise. The move toward greater data distribution -- thanks...
The End of Application Deployment: Virtualised Applications Streamline, Secure and Manage Your Business
Hundreds, even thousands, of applications serve as the life blood of each of today's distributed global enterprises - at use in more places and in more ways than ever before....
Accelerating Microsoft Windows Vista Migrations with Citrix XenApp
For many organisations, migration to Microsoft Windows Vista is not a question of "if" but "when." This inevitability is causing companies to start asking the difficult questions. This white paper...
Advances in Database Technology
Technological change, facilitated with the continuous advancements in information technology, is mainly driven by two forces. Database technology is responding to changes in (1) the amount and (2) the format...
An Information Discovery Process for Interoperable Heterogeneous Databases
An important issue when dealing with interoperability of heterogeneous databases is information discovery. This is the location and identification of information that is relevant, identical, similar or related to the...
