Message
From
19/03/2010 11:08:04
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Cost of query
Environment versions
SQL Server:
SQL Server 2005
Application:
Desktop
Miscellaneous
Thread ID:
01455721
Message ID:
01455721
Views:
111
Hi, people
When running a query I got the message
'The query has been canceled because the estimatesd cost of this query (445) exceeds the configured threshold of 300.'
Is that possible to change this value? Where?
What are the implications to the overall performance ?
TIA
When running a query I got the message
'The query has been canceled because the estimatesd cost of this query (445) exceeds the configured threshold of 300.'
Is that possible to change this value? Where?
What are the implications to the overall performance ?
TIA