Originally posted by desmondliu
it is a view that we going to bring over through the db-link. so do you mean only the group by functions will engender the usage of temp ts and not other functions.
No, not only GROUP BY. Also:

- ORDER BY in a view
- MERGE JOINS
- analytical functions
- UNIQUE operator
- UNION/INTERSECT/MINUS operators
- ... probably many others that I can't remember right now...