DB2 for LUW

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

May 14, 2010 03:00 PM

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.

pdf file
NA10D14.pdf   131 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.