Limiting the Number of Rows

Use the max_docs pseudo column to limit the number of rows returned by the Full-Text Search engine. The fewer the number of rows returned by the Full-Text Search engine, the faster Adaptive Server can process the join between the source table and the index table.