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
11799
August 21, 2010 01:15PM
3961
August 22, 2010 04:45PM
2945
August 23, 2010 06:31AM
2531
August 23, 2010 07:20AM
2387
August 23, 2010 09:20PM
2200
August 24, 2010 02:14AM
2209
August 25, 2010 12:12AM
2252
August 25, 2010 02:36AM
Re: Statistics bottleneck on large table
2398
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.