19.08.2015 10:26, 'Mr. John' wrote: > now index is used if I call > SELECT * FROM MYPROC(...) > but I use it in other procedures,no join on it just simply SELECT .. > FROM MYPROC(...) in this case I can see in the plan : > ...(MYPROC NATURAL)...
That' OK. In complex plans, (MY_PROC NATURAL) just means a select from a procedure, it says nothing about actual plans inside MY_PROC. Dmitry
