Using Character Slice Index in InterSystems IRIS

Опубликовано: 22 Июнь 2026
на канале: InterSystems Developers
168
5

Learn about the Character Slice Index, first introduced back in June 2008. Inspired by bit-slice indexing for numerical data, this approach offers a unique way to index and search for individual characters within texts—ideal for languages like Japanese and Chinese, where single characters carry substantial meaning.

In this presentation, you'll learn how character slicing works, leveraging a specialized data type that defines language-specific word patterns to enhance text indexing performance. We’ll run a live demo using SQL on a test dataset, comparing the performance and efficiency of character indexing versus traditional approaches.

🗣 Presenter: Robert Cemper

Video created for the InterSystems Tech Video Challenge: https://community.intersystems.com/po...