Text Search in DB2

• Text Extender (TE)

• Text indexes on DB2 tables

  • Relate index entries back to individual records
  • Triggers keep text and text indexes in synch

• More info: [A. Maier and D. Simmen. DB2 Optimization in Support of Full Text Search. IEEE Data Eng. Bulletin]

Notes: