Showing posts with label Performance. Show all posts
Showing posts with label Performance. Show all posts
Tuesday, June 5, 2012
Sybase IQ - Word Index limitations
"words exceeding the maximum permitted word length not supported" error means you did not defined enough/correct delimiters for WD index.
Maximum word length for WD index is 255 characters. You need to delimit your text with correct delimiters to reduce maximum word length under 255.
For columns, which holds SQL statements, delimited by ' ,;=' clause seems valid.This statement means string will be delimited by any of those characters. '.' character is willingly ommited to be able to find 'owner.tablename' format faster.
You may check Sybase Infocenter for detailed information.
Maximum word length for WD index is 255 characters. You need to delimit your text with correct delimiters to reduce maximum word length under 255.
For columns, which holds SQL statements, delimited by ' ,;=' clause seems valid.This statement means string will be delimited by any of those characters. '.' character is willingly ommited to be able to find 'owner.tablename' format faster.
You may check Sybase Infocenter for detailed information.
