RE: Why does ittake long time?

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Thu, 25 Oct 2001 04:44:58 -0700
Message-ID: <F001.003B40A5.20011025045020@fatcity.com>

Have you checked, whether the query will be using the indexes, if u have any...

Nirmal,

-----Original Message-----

From:   Roland.Skoldblom_at_ica.se [SMTP:Roland.Skoldblom_at_ica.se]
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 >> Received on Thu Oct 25 2001 - 06:44:58 CDT