I have some questions, that I like to know to my MSc research.
Lets consider following situation:
I have two small tables A and B.
And two big tables C and D.
I want to put A and B in TimesTen and C and D (because they are to big) in standard Oracle database.
Can I configure system that way, that queries to A and B will be RAM-only queries and queries for C and D will be standard database queries?
I want this to work transparent to user: user makes query and don't know, if he is querying TimesTen or standard Oracle.
If above is possible: What about queries in which user joins A and C? Will A be read from memory or from disk?
I don't need to know how to do it. Only if its possible.