takeing 17 minute 30 second ???
Posted by:
helo worl
Date: February 10, 2005 02:31PM
Question: How to solve the query time ? its takeing 17 minute 30 second ???
Description:
CALLS ROW = 9000
RATE ROW = 27 000
MySql Syntax:
select Zone,Code, (select rate_id from rate where rate_id=zone and c_code=code) from CALLS;
Query Time: 17 minute 30 second
Subject
Written By
Posted
takeing 17 minute 30 second ???
February 10, 2005 02:31PM
February 10, 2005 03:32PM
February 10, 2005 05:30PM
February 11, 2005 04:18AM
February 15, 2005 03:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.