Have you checked, whether the query will be using the indexes, if u have any...
Nirmal,
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2: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 << File: Paintbrush >>
