For example, in the table is only a field,
Build table to table using A disk file group,
And then create the cache to disk file group B,
Do the day after the where field='looking for something like this query, the SQL is a read-only disc B? Or should read B plate and A plate?

Ask this question, because I want to improve the query speed,
Such a condition, to a new record in the table does not exist forever may update or delete,
Is there only to find the list the data,
So I don't know how to read and write cache is the case, want to keep data in mechanical hard disk, the write cache solid-state drives,
But don't know to find it, you just need to read the cache, or cache and data should be read,

Please explain the great god, learning,