There is an inline view in this query. Did you check if it is using appropriate indexes (if it is retrieving lot of records).
In total, check the execution plan for this query. Post it if you still find no issue with it.
rgds
amar
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject: Why does ittake long time?
Hallo,
Why does this query take so longtime to run...At least 20 minutes it is just a simple count...
(Embedded image moved to file: pic24685.pcx)
Thanks in advance
Roland Sk�ldblom
