Querying and data manipulation
Now that we have a memory-optimized table, the next logical step is to start querying the table and manipulating the data stored inside it.
We have two methods of interacting with these memory-optimized objects. Firstly, we can issue standard T-SQL queries and allow the SQL Server Query Optimizer to deal with accessing this new type of table. The second method is to use Natively Compiled Stored Procedures.
![](https://static.packt-cdn.com/products/9781786465344/graphics/image_11_004.jpg)
Figure 11.4: Overview of the SQL Server engine illustrating Query Interop between In-Memory OLTP and "normal" OLTP
In Figure 11.4, we can see a simplified diagram of a query that is either querying "normal" tables or memory-optimized tables. In the center of the diagram is a node titled Query Interop. This is a mechanism that is responsible for enabling "normal" interpreted T-SQL statements to access memory optimized tables. Note that this is a one-way mechanism and that the natively compiled stored procedures are not able to access traditional objects, only...