ramana3327 (9/2/2014)
2) We can't use for very large queries because it will impact the memory
Nope, nothing to do with the query size.
3) Just this feature is for small queries and which is not getting performance improvement through the normal features
Not really. It's not about the size of the query, though data-warehouse style queries are very unlikely to benefit.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability