Top "Query-hints" questions

Oracle LEADING hint -- why is this required?

Suddenly (but unfortunately I don't know when "suddenly" was; I know it ran fine at some point in the past) …

sql oracle query-hints

SELECT TOP is slow, regardless of ORDER BY

I have a fairly complex query in SQL Server running against a view, in the form: SELECT * FROM myview, foo, …

sql-server sql-server-2005 tsql sql-execution-plan query-hints

SQL Server : the maximum recursion 100 has been exhausted before statement completion

I have a query that is returning an error with the maximum levels of recursion exceeded. I know how to …

sql sql-server query-hints

Should I use Query Hint Fast number_rows / FASTFIRSTROW?

I was reading over the documentation for query hints: http://msdn.microsoft.com/en-us/library/ms181714(SQL.90).aspx And noticed …

sql sql-server query-hints

SearchView not showing queryHint text

I have a search view with a background drawable, but I can't seem to get the text to appear no …

android android-studio searchview query-hints

Adding a query hint when calling Table-Valued Function

I'm calling a Table-Valued Function from entity framework and need to be able to add the option (recompile) to it …

sql-server entity-framework sql-server-2012 query-hints

Get SQL Server to use index seek + key lookup instead of clustered index scan, without WITH (FORCESEEK)

Version: SQL Server 2008 R2 Database: AdventureWorks 2008R2 from http://msftdbprodsamples.codeplex.com/releases/view/55926 Query: SELECT TOP 10 * FROM Person.Person …

sql-server indexing query-hints