Ho do i place a table in memory that is going to used multiple times and has very few updates done on it?
Printable View
Ho do i place a table in memory that is going to used multiple times and has very few updates done on it?
This will cache the table in memory...
ALTER TABLE table_name CACHE;
You will have to analyze the table before caching.