Re: Why does ittake long time?

Thu, 25 Oct 2001 12:34:04 -0700

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 -----
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:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
    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 >>

Reply via email to