Home » RDBMS Server » Performance Tuning » Query Slow - any ideas how to speed it up??? here's what I have...
Query Slow - any ideas how to speed it up??? here's what I have... [message #170731] Fri, 05 May 2006 00:11 Go to next message
chetwyn
Messages: 73
Registered: December 2005
Member
The query is used to list the most popular web sites.

So the columns are:
a1.title title, a1.internet_url, count(a2.internet_url) hitsno, a1.ref_pk

and the code is:

Select a1.title title, a1.internet_url, count(a2.internet_url) hitsno, a1.ref_pk
from mis_internet a1, mis_internet_log a2
where a1.internet_url = a2.internet_url 
and a2.date_stamp >= sysdate-60
group by a1.title, a1.internet_url, a1.ref_pk
order by count(a2.internet_url) desc

Business Development (Word)                                 	www.google.com.au                                           	5564                                   	3516
Search Engine - Google                                      	www.google.com.au                                           	5564                                   	1042
Google                                                      	www.google.com                                              	5487                                   	2377
Sydney Morning Herald                                       	www.smh.com.au                                              	3478                                   	36
Sydney Morning Herald Online                                	www.smh.com.au                                              	3478                                   	1299
Sydney Morning Herald                                       	www.smh.com.au                                              	3478                                   	3407
Bureau of Meteorology                                       	www.bom.gov.au                                              	3131                                   	1167



Please help??

Thx.


Re: Query Slow - any ideas how to speed it up??? here's what I have... [message #170744 is a reply to message #170731] Fri, 05 May 2006 01:12 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Please post your query's explain plan and execution statistics.

Also, please read this forum's sticky.
Re: Query Slow - any ideas how to speed it up??? here's what I have... [message #170752 is a reply to message #170731] Fri, 05 May 2006 01:25 Go to previous message
chetwyn
Messages: 73
Registered: December 2005
Member
yep - posted in wrong section and with oput explain plan... silly me. Sorry guys.

Please disregard this post as it's not an issue any more.

Thanks.
Previous Topic: Query Tuning
Next Topic: Queries perform slow
Goto Forum:
  


Current Time: Wed May 29 20:16:04 CDT 2024