Option (FAST n)

[redlam]

Has anyone had any experience using the query option "Option (FAST n)"?

BOL says this: Specifies that the query is optimized for fast retrieval of the first number_rows (a nonnegative integer). After the first number_rows are returned, the query continues execution and produces its full result set.

Does this actually work? I'd be interested in any comments from anyone who has implemented this option.

Thanks in advance...

 

[redlam]

I should clarify... I have tested this option and not seen any difference. I'm wondering if anyone has had any success.
Thanks again!!!

 

[fluteplr]

It really varies by query. I have had a few where it helped, but in general it is not worth the trouble.

 

[redlam]

Bummer. Thanks.

 

[tlbroadbent]

If the query does any aggregation, order by, or UNION operations, to name a few, the option won't do much if any good because all of those operations must occur before SQL can begin to return any rows. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.