Re: Statistics bottleneck on large table
Posted by:
Rick James
Date: August 25, 2010 08:54PM
If
SELECT * FROM `test` WHERE lat = 10 AND lon = 64 AND vt = '2010-08-23 00:00:00';
(with different values) is the only query you do, then there is nothing to change, and nothing that will speed up the query.
(`vt`,`lat`,`lon`) (in any order) is the perfect index.
Do you have multiple connections, each doing such queries? If so, they can mostly run in parallel.
Subject
Views
Written By
Posted
11611
August 21, 2010 01:15PM
3890
August 22, 2010 04:45PM
2881
August 23, 2010 06:31AM
2464
August 23, 2010 07:20AM
2317
August 23, 2010 09:20PM
2133
August 24, 2010 02:14AM
2133
August 25, 2010 12:12AM
2173
August 25, 2010 02:36AM
Re: Statistics bottleneck on large table
2331
August 25, 2010 08:54PM
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.