I encountered an odd situation where appending OPTION (RECOMPILE) to my query causes it to run in half a second, while omitting it causes the query to take well over five minutes. This is the case...

I'm calling a Table-Valued Function from entity framework and need to be able to add the option (recompile) to it because the execution plan it picks up is not optimal. Running the query in SQL Ser...

In my application I have to add many records. I am using the following construct: INSERT /*+ append parallel(t1, 4) parallel(t2, 4) */ ALL INTO t1 (col1, col2, col3) VALUES ('val1_1', 'val1_2', ...

I have a statement that runs on Oracle database server. The statement has about 5 joins and there is nothing unusual there. It looks pretty much like below: SELECT field1, field2, field3, ... FROM...

Update: I've created a suggestion to implement hint control in a future version of EF. Go here to vote for it. I have a problem where one of my Entity Framework (EF) queries is taking a very long ...

I have a fairly complex query in SQL Server running against a view, in the form: SELECT * FROM myview, foo, bar WHERE shared=1 AND [joins and other stuff] ORDER BY sortcode; The query plan a...

Version: SQL Server 2008 R2 Database: AdventureWorks 2008R2 from http://msftdbprodsamples.codeplex.com/releases/view/55926 Query: SELECT TOP 10 * FROM Person.Person --WITH (FORCESEEK) WHERE L...

I have an indexed view that I need to specify the noexpand hint for in order for it to perform reasonably. Unfortunately as seen with regard to modifying the Linq to SQL generated T-SQL query from ...

Suddenly (but unfortunately I don't know when "suddenly" was; I know it ran fine at some point in the past) one of my queries started taking 7+ seconds instead of milliseconds to execute. I have 1 ...

I was reading over the documentation for query hints: http://msdn.microsoft.com/en-us/library/ms181714(SQL.90).aspx And noticed this: FAST number_rows Specifies that the query is optimized for fas...