Rene probably misunderstood that you were asking for optimizing a group of SQL statements (or a “collection” of SQL) when she answered your question.
If I understand your question correctly, you were asking if the Optimizer will support the Oracle Collection type (or other object types). The answer is that these datatype are not supported in both Scanning and Optimization. That is, they will not be recognized when you scan source and there will not be advices or alternatives generated when you optimize a SQL using these datatype. As for the planning, we are looking to support them in future versions. There is no concrete plan to support all object datatypes in the next release but we are looking to provide more and more support to them in coming releases (Hope you understand that it will take time to have complete support of the object datatype syntax).
Let me know if this answered your question.