What I understand about the memory optimized tables is

1)We can't use for frequently where schema changes frequently. If schema changes every time memory optimized tables need to be recreate

2) We can't use for very large queries because it will impact the memory

3) Just this feature is for small queries and which is not getting performance improvement through the normal features