For a non-continuable query, you can change the query in
two main ways to improve search performance: by adding more restrictive
search conditions for the properties that are indexed and by limiting
the number of rows that are returned.
To limit the number of returned rows, add the
TOP N keyword
to the query. (In an application, you might indirectly add this keyword
when you specify the maximum number of returned rows in the application
interface.) For example, the following query returns a maximum of
200 rows:
SELECT TOP 200 Id
FROM Document
WHERE Property1 = 'value'
Important: The user might not have access to some rows
because of security permissions; these non-accessible rows are automatically
removed from the returned results. Because security permissions have
to be checked on each row, many rows might need to be retrieved to
find rows that are accessible. For this reason, do not rely on security
permissions to limit the number of rows that a query returns.
Remember: While the initial SQL execution of the database
query might be fast, the overall user search might still be slow because
of other query activities. For more information, see
Query run time.