Re: Extremely slow query
Posted by:
Rick James
Date: December 19, 2008 01:11AM
ALTER TABLE vp_top_summary
DROP INDEX vpts_i,
ADD PRIMARY KEY (id),
ADD INDEX (host_ip, report_id);
(and hope you don't have any dup ids)
Subject
Views
Written By
Posted
3410
December 01, 2008 12:53AM
1862
December 05, 2008 02:10AM
Re: Extremely slow query
1675
December 19, 2008 01:11AM
1728
January 04, 2009 09:38PM
1656
January 05, 2009 07:18PM
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.