Having data present in memory will help analytical queries run much faster compared to traditional disk or flash storage. We have a new database feature called In Memory database from 12c onwards to help with anlytical load. 683 more words