Skip to Content
0
Former Member
Nov 10, 2006 at 11:12 AM

OPTION (FAST 100)

43 Views

Maybe, here, someone could help me.

I've been edited a BDoc write on CRM server. this Bdoc is converting to a sql statement executed on local SQL server DB.

The generated query contains OPTION (FAST 100) at the end. In some case this option make the query resultset time very long: a particular execution that return 16 record can from 2 second to 48!!!!!!

how can i disable on the server the insert of this options?

THX