This content has been marked as final. Show 2 replies
1 person found this helpful
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.
Thank you Denis.
The principle of combining the database and R can be so powerful, which is why I was getting excited about seeing the SQL code in action. It would also aid in program testing.