Hi, I need some clarification about what is in memory and what is on disk.
I have a table that is created from a 16GB CSV file; the table is created using ‘USING CLUSTERED COLUMNSTORE.’ I do see the column files created on the disk, and I can read from the table using the ‘SELECT’.
However, when I check the execution plan, I can see that the majority of time is spent in scanning the column files on the disk. My expectation for the ‘In Memory Database’ was that the tables would be in memory; thus there would be no disk reading during “SELECT.” However, this is not the case.
Is this because my table is created ‘USING CLUSTERED COLUMNSTORE.’? How can I make sure that my table is entirely in memory? How can I make sure that the disk IO is minimal when I do the 'SELECT ’ only?