Does SQLite favour keeping indexes in its cache when possible?
===

I'm working in a memory constrained environment with SQLite 3. 

I'll be setting the PRAGMA cache size to be (say) 1MB.

Assume I have 2MB of data, and 100Kb of index data. 

Will SQLite attempt to keep the indexes in its memory cache over and above the data itself (leaving 900Kb of data in cache)?  

If not, how are the indexes accessed from a memory perspective?

Thanks. 


