Home » Other » General » how does stored procedure wok between timesten and oracle database
how does stored procedure wok between timesten and oracle database [message #490733] Thu, 27 January 2011 01:57 Go to next message
okoha
Messages: 3
Registered: January 2011
Junior Member
I will use timesten in-memory database cache load data from oracle database into timesten database
In oracle database there are tableA and tableB two tables
in procedure written like below
select A.*,B.* from tableA A join tableB B on A.id = B.id
If data of tableA had been cached into timesten but tableB not cached how would the procedure above work?
would it select data of tableA from timesten and select tableB from oracle database? or both from oracle database ?
Re: how does stored procedure wok between timesten and oracle database [message #490734 is a reply to message #490733] Thu, 27 January 2011 01:59 Go to previous message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is not the anser in the (second) document I posted you at http://www.orafaq.com/forum/mv/msg/165112/490337/102589/#msg_490337.

Regards
Michel
Previous Topic: PERFSTATS
Next Topic: Loading data from OLTP schema to star schema
Goto Forum:
  


Current Time: Mon Sep 20 23:55:07 CDT 2021