From sqlgreg@pacbell.net Thu, 25 Oct 2001 12:34:04 -0700 From: Greg Moore Date: Thu, 25 Oct 2001 12:34:04 -0700 Subject: Re: Why does ittake long time? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Why does ittake long time? Also, there's no WHERE clause condition that joins the two tables.  So you're getting a Cartesian product.  Is that what you want?  It might be the reason the query is taking so long....
----- Original Message -----
From: Nirmal Kumar Muthu Kumaran To: Multiple recipients of list ORACLE-L Sent: Thursday, October 25, 2001 5:50 AM Subject: RE: Why does ittake long time? Have you checked, whether the query will be using the indexes, if u have any... Nirmal, -----Original Message----- From:   Roland.Skoldblom@ica.se [SMTP:Roland.Skoldblom@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 >>