Query slow

[netbar]

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..

[noor]

Hello Netbar,

Did you take a look at the execution plan ?