Example: Text Fields
In conventional RDBMS, when a text field is indexed, only exact matching of the text field contents (or Greater-than and Less-than).
- Can search for individual words using pattern matching, but a full scan is required.
Text searching is still done best (and fastest) by specialized text search programs (Search Engines) that we will look at more later.