Adaptive Server version 12.5.2 introduces many new EFTS features.
Only users with sa_role can shut down EFTS.
Starting with Adaptive Server version 12.5.2, EFTS returns an integer value for the total number of documents that match a search criteria. This value is returned in a new pseudo column called total_docs.
This is also useful when using the max_docs column, which limits the number of results returned.
In earlier versions of Adaptive Server, EFTS did not support index_any clauses greater than 255 bytes. In Adaptive Server version 12.5.2, EFTS supports index_any clauses up to 16000 bytes.
The column definition for the proxy table is not altered, because the definition does not affect the size of the clause that is sent to EFTS.
In Adaptive Server version 12.5.2 and later, primary keys can be used as the text id column. You can create text indexes on tables that contain an identity column or a suitable primary key. Primary keys defined on a single decimal, numeric, int, smallint, or tinyint column are also eligible. Decimal and numeric columns must have a scale of zero
When creating a text index, EFTS first looks for an IDENTITY column in the source table to use as the ID column of the text index. If an IDENTITY column is not found, EFTS looks for a suitable primary key that it can use as the ID column of the text index.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
