Query hints for SQL Server

Hi,

I see in the documentation that we can use Index Hints and Table Hints in SQL Server. But can we also use "Query Hints" (as per http://msdn.microsoft.com/en-us/library/ms181714.aspx )? Unlike Table Hints, Query hints are not wrapped in "WITH (...)".

John

PS. the reason I actually want these, is because I want to put a SQL comment (generated by my code), into each query that we send to SQL Server (for diagnostic purposes). I'm thinking that if Query Hints are supported, I can just send "/* my diagnostic comment */" through as a "query hint"

Update: I think I've found a totally different way to solve my original problem. So my need for this has probably gone. However, for the sake of completeness, it would still be interesting to me (and potentially to others) to know whether query hints are supported.

No, currently query hints are not something which we expose any hooks for currently. Ill pop a suggestion on the feature request board for this though :)

Jeremy

hi again jeremy

just wanted to ask if how to execute join query in lightspeed thanks :)

Check out http://www.mindscapehq.com/documentation/lightspeed/Advanced-Querying-Techniques/Exploring-the-Query-Object#Toc297195166 for some detail about how to define a join query using the query object - if you are using LINQ just specify something like:

from a in UnitOfWork.Apples
join b in UnitOfWork.Bananas on a.Id equals b.AppleId
select new { a, b }

Jeremy