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

Steps To create 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 Description
Catalog Specifies the full text catalog where the full text index is defined.

Scripting name: FullTextCatalog
Change tracking 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


Scripting name: ChangeTracking

 

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