Query slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Query slow

  1. #1
    Join Date
    Jul 2001
    Posts
    181
    Hi I have the following query
    SELECT Q.quoteid QuoteID,
    I.timestamp TimeStamp,
    Q.timestamp QTimeStamp,
    Q.instrumentid Security,
    Q.buyprice BidPrice,
    Q.sellprice OfferPrice,
    Q.buyqty BidQty,
    Q.sellqty OfferQty,
    Q.participantid Participant,
    QSE.shortdesc Status,
    NVL(Q.indicative, '0') Indicative
    FROM tibex_quote Q,
    tibex_quoteinstruction I,
    tibex_quotestatusenum QSE
    WHERE Q.lastinstid = I.instructionid and
    Q.quotestatus = QSE.quotestatus

    the where clause doing the '=' has millions of rows in each table is there a better way I could rewrite this.

    Thanks in advance..

  2. #2
    Join Date
    Oct 2001
    Posts
    83
    Hello Netbar,

    Did you take a look at the execution plan ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width