Limiting the number of rows

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