Using pseudo columns to request clustered result sets  Writing queries requesting a clustered result set

Chapter 5: Writing Full-Text Search Queries

Preparing to use clustering

Before you request a clustered result set, you must build the text index with the clustering function enabled. See “Enabling query-by-example, summarization, and clustering”.

The Verity clustering algorithm attempts to group similar rows together, based on the values of the following configuration parameters:

Use sp_text_cluster to have a query use values that are different from the default values of these configuration parameters. See sp_text_cluster.





Copyright © 2005. Sybase Inc. All rights reserved. Writing queries requesting a clustered result set

View this book as PDF