What is the fastest type of text query?
The fastest type of query will meet the following conditions: • Single CONTAINS clause • No other conditions in the WHERE clause • EITHER: No “ORDER BY” clause at all, OR just “ORDER BY SCORE(n) DESCEND” together with the “FIRST_ROWS” hint • Only the first page of results is returned (eg. the first 10 or 20 hits).
Related Questions
- How far is Lichfield gillepse from st. Louis, mo?; var unit = { client : chacha_bottom, ype : mpu, width : 464, height : 154, cid : answers_mpu_1, sid : channel, query : query ?
- Who was Robert F. kennedy?; var unit = { client : chacha_top, ype : mpu, width : 432, height : 82, cid : answers_mpu_2, sid : channel, query : query ?
- What is the fastest type of text query?
