Don Burleson recently posted a great article on using Oracle Text indexes to make up for the horrible performance issues caused by ‘%LIKE%’ queries on large blocks of text. I have personally been enjoying keyword searching CONTEXT indexes for quite some time through its various incarnations as the Context Option,