Increasing query performance  Ensuring the correct join order for queries

Chapter 7: Performance and Tuning

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.





Copyright © 2005. Sybase Inc. All rights reserved. Ensuring the correct join order for queries

View this book as PDF