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?

Improve this question
1
  • 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
    Commented May 31, 2018 at 8:41

1 Answer 1

Reset to default
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.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.