We have a SQL table with around 150 mil lines. to execute a query takes a very long time. Having a look at the resources, ram sits at 25% and CPU less than 10% while disk is at 100%.
Is there a way to load the entire table into RAM and work directory from there?
I assume this will also shorten the duration it takes to execute a query.
Do you perhaps have a link on a procedure where i can set this it up guide me in the correct direction.
Thanks in advance