How can I use OPTION(FAST n) -- sql server clients

Tigran
7/30/2003 8:31:02 AM

Good day..
There is one question...
I do

select* from "any_table_name"
option(fast 50)

This all I write in Enterprise Manager's SQl Query
Analyser, but anyway EM me returns records only after it
has loaded all records..
I don't fill things, that how I understood, must does
'option(fast n)'...to return me, possibly fast, 50 records.
How can I resolve this problem..

Allan Mitchell
7/31/2003 7:22:34 AM

Enterprise Managers Query tool and Query Analyser are two different beasts.
The former is used for very quick/non complicated queries and the latter is
used for industrial strength stuff.

Try using QA. Works for me

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server clients : How can I use OPTION(FAST n)