Unstructured Data Queries

Learn about querying large object data, including the full text search capability that handles unstructured and semistructured data.

• Full Text Search
  Full text search uses TEXT indexes to quickly find all instances of a term (word) in a database without having to scan table rows.
• NGRAM TEXT Index Searches
  Fuzzy and non-fuzzy search capability over a TEXT index is possible for TEXT indexes of type NGRAM.
• Queries on LONG BINARY Columns
  In WHERE clauses of the SELECT statement, you can use LONG BINARY columns only in IS NULL and IS NOT NULL expressions, in addition to the BYTE_LENGTH64, BYTE_SUBSTR64, BYTE_SUBSTR, BIT_LENGTH, OCTET_LENGTH, CHARINDEX, and LOCATE functions.
• Queries on LONG VARCHAR Columns
  In WHERE clauses of the SELECT statement, you can use LONG VARCHAR columns only in IS NULL and IS NOT NULL expressions, in addition to the BIT_LENGTH, CHAR_LENGTH, CHAR_LENGTH64, CHARINDEX, LOCATE, OCTET_LENGTH, PATINDEX, SUBSTRING64, and SUBSTRING functions.
• Performance Monitoring of LONG BINARY and LONG VARCHAR Columns
  The performance monitor displays performance data for LONG BINARY and LONG VARCHAR columns.