In this blog post, you’ll learn more about the Sybase Error No matching text index. and the reason for receiving this error
Sybase SQL Error Message
No matching text index.
Reason for this Error
A single text index must exist on all columns referenced in a CONTAINS query.