query takes too much time
Posted by:
alev mutlu
Date: August 31, 2009 09:26AM
Hi,
I am running the below query and it is taking too long to response. How can I improve it?
SELECT COUNT(DISTINCT CONCAT(r3.name,'-',r4.name from mesh r0, mesh r1, neighbour_yz r2, element r3, number r4 where r3.name=r4.num
Subject
Views
Written By
Posted
query takes too much time
3422
August 31, 2009 09:26AM
2004
September 01, 2009 10:34PM
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.