2

I am trying to rewrite a stored procedure to Natively compiled stored procedure. The procedure refers to 20 tables, these tables are normal tables (non memory optimised) and I am using 5 views related to it. Is it possible to create a Natively Compiled stored procedure without converting any of these objects to Memory optimised tables?

Rohith
  • 769
  • 7
  • 15
  • 1
    I think the answer is no, they must operate on memory-optimized tables, but the docs don't explicitly say they must be, just imply it. – Andrew May 31 '18 at 08:41

1 Answers1

1

Natively compiled procedures cannot access non-in-memory tables.

See Aaron's answer here: https://dba.stackexchange.com/questions/180172/use-natively-compiled-stored-procedures-in-disk-based-tables.

Niels Berglund
  • 1,713
  • 8
  • 6