How can I add Sql Optimizer hint to a query generated by DetachedCriteria? I have a DatachedCriteria that generates query:
=============== SELECT TOP 10 ID, Name FROM Product WHERE contains(Name, '"White Dress"') ORDER BY DateMadeNew desc =============== using approach here: http://xlib.wordpress.com/2009/12/04/integrating-freetext-search-in-nhibernate-detached-criteria/ But this query needs " OPTION (HASH JOIN)" at the end to run optimally. Is this possible? Eric -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
