Step 2. Checking for an IDENTITY column or primary key  Step 4. Creating the text index and index table

Chapter 3: Configuring Adaptive Server for Full-Text Searches

Step 3. Creating a unique index on the IDENTITY column

This step is optional. To enhance performance, Sybase recommends that you create a unique index that contains only the IDENTITY column. For example, to create a unique index named reviews_id on the IDENTITY column created in the previous procedure, issue:

create unique index reviews_id on reviews(id)

For more information about creating a unique index, see Chapter 11, “Creating Indexes on Tables,” ofthe Transact-SQL User’s Guide.




Copyright © 2005. Sybase Inc. All rights reserved. Step 4. Creating the text index and index table

View this book as PDF