diff options
| author | Jochen Topf <jochen@topf.org> | 2015-03-06 20:55:31 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2015-03-06 20:55:31 +0100 |
| commit | 48240be189cb6453465103ff535c3f22aed48f8e (patch) | |
| tree | 95486f3736a452ccbbf7473cac12ac692bc67552 /sources/db/post_similar_keys.sql | |
| parent | 0e97f9b3773585d8fb76659dc710726a888c4851 (diff) | |
| download | taginfo-48240be189cb6453465103ff535c3f22aed48f8e.tar taginfo-48240be189cb6453465103ff535c3f22aed48f8e.tar.gz | |
Move creation of index forward...
Diffstat (limited to 'sources/db/post_similar_keys.sql')
| -rw-r--r-- | sources/db/post_similar_keys.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sources/db/post_similar_keys.sql b/sources/db/post_similar_keys.sql index 03b000b..f28d8b2 100644 --- a/sources/db/post_similar_keys.sql +++ b/sources/db/post_similar_keys.sql @@ -13,6 +13,11 @@ PRAGMA cache_size = 5000000; -- ============================================================================ +-- need this index now... +CREATE UNIQUE INDEX keys_key_idx ON keys (key); + +-- ============================================================================ + -- For all keys found to be similar earlier, we get the counts how often they -- appear in the OSM database and store this data in the same table for easy -- access. |