Re: Why does ittake long time?

From: Greg Moore <sqlgreg_at_pacbell.net>
Date: Thu, 25 Oct 2001 12:34:04 -0700
Message-ID: <F001.003B4F09.20011025124525@fatcity.com>

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....
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Nirmal Kumar Muthu Kumaran To: <A href="" title=ORACLE-L_at_fatcity.com>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----- <FONT

    face=Arial size=1>From:   <A 
    href="">Roland.Skoldblom_at_ica.se [<A 
    href="">SMTP:Roland.Skoldblom_at_ica.se] 

    Sent:   <FONT face=Arial

    size=1>Thursday, October 25, 2001 2:26 PM <FONT face=Arial 
    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT 
    face=Arial size=1>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 - 14:34:04 CDT