EXPLAIN PLAN

From: Tanasescu Iosif <iosif.tanasescu_at_bellsygma.com>
Date: Fri, 12 Mar 1999 14:38:19 -0500
Message-ID: <36E96D2B.821A140D@bellsygma.com>

Hi,

Could anybody tell me how an explain plan (eevn for a querry impliyng 10 tables in outer join) could take 12 minutes to be executed, in an environment where no other processes are running, only one database, sga fo 250Mb (from 1.5 Gb machine), 2 CPU, HP-UX 10.20 and ORACLE 7.3.4 (no patches)

--
Iosif Tanasescu
Conseiller Princ.
Le Group CGI Inc.
1800 McGill College, Suite 1600
Montreal, Quebec, Canada H3A 3J6

Tel:   (514) 281-0149
Pager: (514) 580-1708
Fax:   (514) 847-0071

IIS:itanases
E_mail:Iosif.Tanasescu_at_BellSygma.com Received on Fri Mar 12 1999 - 13:38:19 CST