aarded (10/20/2014)
OK, thanks.Your example by replacing the select of the MIN(Name) and MAX(Name) by selecting the name of the Min and Max ID is not valid because in real live the min and max Name do not correspond with the min and max ID.
But I understand why my query was slow.
So in-memory tables are not always so optimal, especially in range and some functions (Count, Min or Max).
Rgds.
Ok. Thanks. I was only basing it off the example that you provided. I didn't know that your example was not based on your real-life scenario.
And yes, in memory is not a magic bullet for everything. As always, research and test over and over again.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events