Re: Why does ittake long time?

From: Jan Pruner <jan_at_pruner.cz>
Date: Thu, 25 Oct 2001 05:51:17 -0700
Message-ID: <F001.003B4061.20011025043526@fatcity.com>

Hmm, nice picture. Why don't you simply copy&paste your select?

Send a tables create script and tell us what indexes you have on tables.

And what is VGRP and ART_GRP etc.

JP

On Thu 25. October 2001 13:25, you wrote:
> 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

---

Content-Type: application/octet-stream; charset="iso-8859-1"; name="pic24685.pcx"

Content-Transfer-Encoding: base64
Content-Description: Paintbrush
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Thu Oct 25 2001 - 07:51:17 CDT