https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/a-guide-to-query-processing-for-memory-optimized-tables Önce file group ve container oluşturmalıyız -------------------------------------------------- ALTER DATABASE test ADD FILEGROUP imoltp_mod CONTAINS MEMORY_OPTIMIZED_DATA ALTER DATABASE AdventureWorks2014 ADD FILE ( name = 'imoltp_mod1', filename = 'D:\MSSQL\SQLDATA\MSSQL13.MSSQLSERVER\MSSQL\container_data\imoltp_mod1' ) TO FILEGROUP test Sonra tabloyu Memory ü zerinde oluşturmalıyız.CREATE TABLE dbo.[Customer] ( CustomerID NCHAR ( 5 ) NOT NULL PRIMARY KEY NONCLUSTERED, ContactName nvarchar ( 30 ) NOT NULL ) WITH ( MEMORY_OPTIMIZED = ON ) GO CREATE TABLE dbo.[Order] ( OrderID INT NOT NULL PRIMARY KEY NONCLUSTERED, CustomerID NCHAR ( 5 ) NOT NULL INDEX IX_CustomerID HASH ( CustomerID ) WITH ( BUCKET_COUNT = 100000 ), OrderDate DATE NOT NULL INDEX IX_OrderDate HASH ( OrderDate ) WITH ( BUCKET_COUNT = 100000 ) ) WITH ( MEMORY_OPTIMIZED = ON ) GO SELECT o.OrderID, c.* FROM dbo.[Customer] c INNER JOIN dbo.[Order] o ON c.CustomerID = o.CustomerID Stored Procedure: ------------------ CREATE PROCEDURE usp_SampleJoin WITH NATIVE_COMPILATION, SCHEMABINDING, EXECUTE AS OWNER AS BEGIN ATOMIC WITH ( TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE = 'english' ) SELECT o.OrderID, c.CustomerID, c.ContactName FROM dbo.[Order] o INNER JOIN dbo.[Customer] c ON c.CustomerID = o.CustomerID END
