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 list ORACLE-L 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, no error message) it's happening when: INSERT INTO TABLE1 SELECT FUNCTION(X) FROM TABLE I need some help. Merry Christmas, Ciprian MAFTEI Systems Analyst Telequote Network Romania -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mac INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
