Product Documentation
Abstract
There can be performance problems if you use the LIKE operand when you run queries in IBM® Rational® ClearQuest® using Microsoft® SQL Server. These queries might respond very slowly and can sometimes result in blocking other users. This document describes how to enable full-text indexing on a Microsoft SQL Server 2000 database.
Content
This enhances the ClearQuest ability to do text searches on SQL Server. Until version 2003.06.15, ClearQuest would perform a filtered query by using the operand LIKE. By enabling this new capability, you allow ClearQuest to search within SQL server with the CONTAINS operand.
Users of ClearQuest databases will be provided a list of Fields that have been full-text indexed on the Tables where they have been full-text indexed along with the CQMS Sites where they have been indexed if CQMS is being used.
Illustrative Text
Full-text indexing on CQ SQL Server-based databases is a full-word-only look up, which means a CQ Query will not find 'performance' if 'erformance' is entered. For those fields that are full-text indexed at each CQ or CQMS site where they are indexed.
For more information on this functionality, consult your SQL Server documentation or database administrator.
Refer to the attached document.
Section 1: Prerequisites
Section 2: Enabling full-text indexing
Note 1: All steps described in 4a. through 4l. must be executed for each table that will be Full-Text Indexed.
Also, from time to time, you might want to populate the catalog manually. This is described in step 4j.
Note 2: With Full-Text Searching enabled, now only substrings at the beginning of the string are matched. Consider the case where the query filter is CONTAINS and the value supplied is “xyz”. If there are two candidates such as "abcxyz" and "xyz123", only "xyz123" will be considered a match. This is default for all search engines in order to increase performance.
Section 3: Appendix
Sample script
Product Synonym
CQ
Was this topic helpful?
Document Information
More support for:
Rational ClearQuest
Software version:
2003.06.00, 2003.06.15, 2003.06.16, 7.0, 7.0.0.1, 7.0.1
Operating system(s):
Windows
Document number:
317889
Modified date:
04 December 2018
UID
swg27005787