Kbase P23604: When will Word-indexes on Oracle DataServer and MS-SQL DataServer be supported ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/01/2011 |
|
Status: Unverified
GOAL:
When will Word-indexes on Oracle DataServer and MS-SQL DataServer be supported ?
FIX:
There are no plans to support word indexes because word indexing is a Progress feature which is not supported the same in Oracle or SQL Server.
They do have full text search capabilities but it is not the same.
Information taken from the Documentation about word indexing is listed below:
From Oracle DataServer:
Word Indexes
Due to technical differences between the Oracle and Progress RDBMSs, word indexes are not supported with the Progress Oracle DataServer. One possible workaround for this problem involves keeping the column to be word indexed in a separate Progress database with links to the originating record in the Oracle data manager.
From MS SQL Server DataServer
Word Indexing
Word indexing is a Progress database-specific feature. At the very least, any code that uses the CONTAINS clause in a query must be removed or eliminated from the code at compile time using preprocessor statements. See the "Migration Issues" section for more information on using preprocessor statements.
SQL Server has a feature that is similar to word indexing called Full Text Search. Though these features are similar, they are not equivalent. Full Text Search indexes are not updated automatically. Administrative functions must be implemented to update Full Text indexes. Due to the performance of the update, there will always be a period of time between when the database change is made and when it is reflected in the Full Text index. Using Full Text Search in place of word indexing requires a considerable amount of design and coding. Support for Full Text Search is not currently part of the DataServer product. If you would like help in designing and/or implementing this type of feature, contact Progress Software Consulting.
For more information read the MS SQL Server Guide under Initial programming Considerations > FOR Statement > Features and language differences section.