Hi All,
In one of my program unit I am having to sequel statements and both of them are making use of a table suppose table eg_table and same columns.
I am having performance issue because of number of iterations so i thought that CTE can help here.
If I use CTE for same table at two places will Oracle store it in memory at one place only?
Will all 50 sessions making use of program unit will fetch from same memory place ?