Am 10.12.2013 um 10:59 schrieb Dan Kennedy :
> On 12/10/2013 02:44 PM, skywind mailing lists wrote:
>> This is an example that the ANALYZE command leads to a wrong query plan for
>> RTrees:
>>
>> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
>>
On 12/10/2013 02:44 PM, skywind mailing lists wrote:
This is an example that the ANALYZE command leads to a wrong query plan for
RTrees:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
This is an example that the ANALYZE command leads to a wrong query plan for
RTrees:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
FromLongitude,TillLongitude);
INSERT INTO A VALUES(1,0,0,0);
INSERT
3 matches
Mail list logo