By Maria Colgan-Oracle on Aug 17, 2014
In my previous blog posts, I described how to install, enable, and populate the In-Memory column store (IM column store). This week's post focuses on how data is accessed within the IM column store.
Let’s take a simple query “What is the most expensive air-mail order we have received to date?”
SELECT Max(lo_ordtotalprice) most_expensive_order
WHERE lo_shipmode = 5;