Articles & Content


High Performance Free Form Text Searching in DB2: Text Search vrs NSE 9.7 (D14)

Topic: 2010 NA

Subtopic: DB2 for LUW

DATE: 2010-5-14 (09:45 AM - 10:45 AM)
SPEAKERS: Robert Donaldson (LSSiData)

This presentation discusses full text search options in DB2. Solutions compared from a performance perspective are: Word support tables, old legacy NSE, Text Search (introduced in DB2 9.5) and the new NSE introduced in 9.7. Capabilities are compared with main focus on performance and usage limitations and notes. Text searching in DB2 7.2, 8.x, and 9.1, was almost usable. Often unstable if you had lots of text indexes. 9.5 introduced a new Text Search based on the OmniFind engine, solid stability, but indexing performance was not as good. DB2 9.7 brings in a far improved NSE that delivers both the stability we've been waiting for and high performance. Special attention is on the improvements that make NSE 9.7 a true enterprise solution that is has never been in the past. Discard your prior experiences with NSE, it's worth a new look. The old performance and stability limitations of parallel indexing are gone.

EXP. LEVEL: Intermediate,Advanced


Know what free form text search options are available in DB2 UDB 9.1, 9.5, and 9.7. Old NSE (DB2 7.2, 8.x, 9.1, 9.5), Text Search (introduced in DB2 9.5), New NSE 9.7, and the old fashioned word support table method.

Compare the functionality between the text search options.

Real world indexing performance and space requirements.

Text indexing update considerations.

Things I've learned to watch out for and advise on usage, primarily relating to NSE.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.