Chapter 15 DBMS-Specific Features


Full-text indexes

A full-text index stores information about significant words and their location within a given column. This information is used to quickly compute full-text queries that search for rows with particular words or combinations of words. PowerDesigner models full-text indexes as table indexes with an index type set to "Full Text".

Creating a full-text index

  1. Create an index by opening the property sheet of a table, clicking the Indexes tab and clicking the Add a Row tool.
  2. Open the property sheet of the new index by clicking the properties tool, and then select FULLTEXT from the list of Types on the General tab.
  3. Click the Select Class tool to the right of the Class field, in order to specify a supertype.
  4. Click the Microsoft tab and select a catalog from the list and then specify the type of change tracking required.
  5. Click OK to confirm your changes and close the property sheet.

Full-text index properties

You can modify an object's properties from its property sheet. To open a full-text index property sheet, double-click its Browser entry.

In addition to the standard index properties, a full-text index has the following additional properties available on the Microsoft tab:

Name Scripting Name Description
Catalog FullTextCatalog Specifies the full text catalog where the full text index is defined.
Change tracking ChangeTracking Specifies whether or not SQL Server maintains a list of all changes to the indexed data. You can choose between:

  • manual
  • auto
  • off
  • off, no population

 


Copyright (C) 2006. Sybase Inc. All rights reserved.