"mac"
.net>cc:
What does the session statistics say when you are running the query?
Do an explain plan of both the queries and see the difference. Check the
session statistics for both the queries.
Regards
Naveen
-Original Message-
Sent: Tuesday, December 24, 2002 2:34 PM
To: Multiple recipients of lis
Oracle 817 on W2k:
SELECT FUNCTION(X) FROM TABLE works fine.
SELECT COUNT (*) FROM
(SELECT FUNCTION(X) FROM TABLE) where the function and the table are the
same as above, takes hours and hours, without any result, and I have to stop
it. There is NO ERROR MESSAGE.
The same story (no result, n
