Home > Ask the AS/400 Experts > DB2/400 and DB2 UDB Questions & Answers > Using indexes on DB2 for i5/OS to improve performance
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Using indexes on DB2 for i5/OS to improve performance

Kent Milligan EXPERT RESPONSE FROM: Kent Milligan

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 23 August 2007
How can I access a sequential file faster with the help of index? Can we use a SELECT statement with index clause to achieve this?

>
EXPERT RESPONSE

Yes, indexes can help the performance of some SELECT statements, provided you have the proper indexes in place for the query optimizer to use.

To get a better understanding of how DB2 for i5/OS can utilize indexes to improve performance, I'd strongly recommending reading the Indexing & Statistics Strategy white paper online.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
i5/OS
How to: Configure a backup schedule between partitions on HMC
Enhancements in the intrusion detection system for i5/OS V6R1
The enhanced DB2 inside i5/OS V6R1
New password-control security features for i5/OS V6R1
Is i5/OS V6R1 in your System i shop's future
New i5/OS features announced as anticipation mounts
IBM previews new version of i5/OS for System i
IBM System i division filing for divorce
IBM eyes SMBs with entry-level System i boxes
iSeries i5/OS: Top 10 Q&As
i5/OS Research

DB2/400 and DB2 UDB
Auditing: RPG with embedded SQL showing up as a changed object
Selecting a PF with multiple members from SQL
Referencing a renamed column on SELECT clause in SQL
Using WebSphere information integrator to access MS server data using SQLRPGLE
Joining files using SQLRPGLE
Querying system catalog tables to determine table alias
Excluding characters from AS/400 DB2 SELECT statements prevents mapping errors
How to use the QQQVEXPL API
Using SQL syntax to override DB2 automatic column name generator on iSeries
Making a file with an automatic key in iSeries with DDS keyword

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
AS/400  (Search400.com)
i5/OS  (Search400.com)
iSeries  (Search400.com)
OS/400  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 1999 - 2008, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts