Tagged Questions
7
votes
3answers
480 views
Can spatial index help a “range - order by - limit” query
Asking this question, specifically for Postgres, as it has good supoort for R-tree/spatial indexes.
We have the following table with a tree structure (Nested Set model) of words and their ...
2
votes
1answer
322 views
How to store GPS coordinate and search places in a radius from a NoSQL DBMS (like DynamoDB)
My team need a DBMS like DynamoDB to store large amount of data, principally places and coordinates.
I've considered to use some GIS-based DBMS (like PostGIS) with an index on the POINT, but DynamoDB ...
1
vote
1answer
742 views
Repair with keycache in mysql runs EVERY time. Can't even log why it's happening
I have a MyISAM table w/ ~1million rows and two indexes - one's a three-column key, and the other is a spatial index for bounded SELECT statements on a separate point column. My insert statements ...
2
votes
1answer
248 views
Creation of spatial index locks the table for hours
I used this code to create a spatial index in SQL Server 2008 R2:
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ...
6
votes
1answer
201 views
Permission to create Spatial Index
Permissions required to create a Spatial Index on a table, for this BOL says:
Requires ALTER permission on the table or view. User must be a member
of the sysadmin fixed server role or the ...
