This content has been marked as final. Show 2 replies
1. Given any R source code, how to view the resulting SQL (or maybe PL/SQL) script?We do not expose this.
2. Would "my" optimization of db objects (e.g. creating an index, ALTERing a procedure) disrupt functionality?It will be considered by the query optimizer when building a plan.
3. Are Vectorize, tapply, lapply, etc fully implemented in Oracle R? I'm guessing the answer will be yes.There is support for some predefined functions. To work with custom functions we have a family of <tt>ore.*Apply</tt> functions.
4. Is every line in R submitted to the db, or do any portions run purely in R? This relates to scenarios (if any) where an operation might be more efficient on SQL than on R or viceversa.It is a mixed mode. ORE makes the decision. But in general not every line is executed right away. The execution is deferred to the point when the results are requested on the client side.