OPTION (FAST 100)

[Former Member]

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

[Former Member]

Hey Angelo,

the OPTION (FAST 100) does not necceserly creates the problem,

this might also be due to a missing index,

the fast results can return if the table is already in the buffer,

try to run the same queries twice, usally the first time takes longer

than the second time.

try to create an index on the selected fields.