Re: Extremely slow queries
Posted by:
Kalvin Lee
Date: March 28, 2006 05:48PM
I've added the composite index of if_id,start_time and it seems to have increased the performance however, it still takes quite a bit (well over 6 minutes). Now, after investigation it seems like the sum(pkt_size) MAY be the cause of the problem. It takes a long time to add up the large recordsets. Is there anyway to speed this up? Summary table is sort of out of the question since the where clause of start_time is so dynamic.
Subject
Views
Written By
Posted
1625
March 24, 2006 01:47AM
1055
March 27, 2006 02:56PM
1166
March 28, 2006 04:52AM
1124
March 28, 2006 09:59AM
Re: Extremely slow queries
1078
March 28, 2006 05:48PM
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.