RE: Why does ittake long time?

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Thu, 25 Oct 2001 05:14:22 -0700
Message-ID: <F001.003B407B.20011025044519@fatcity.com>

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: Roland.Skoldblom_at_ica.se [mailto:Roland.Skoldblom_at_ica.se] 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 Received on Thu Oct 25 2001 - 07:14:22 CDT