[GRASSLIST:10012] Re: How can I create an index on the cat-column?

[Stephan Holl]

Hello Wolfgang,

On Thu, 26 Jan 2006 10:59:11 +0100 (MET) "Wolfgang Qual"
<Wolfgang.Qual at gmx.net> wrote:

> Hi grass-users,
> Recently, I read the following (g.manual v.to.db):
> "If the module is apparently slow and the map attributes are stored
> in an external DBMS such as PostgreSQL, it is highly recommended to
> create an index on the key (category) column."
> How is this done?

Refering to Postgres you could have a look here[1]. At the bottom of
the page an example is explaned.

Since you are probably working with SQLITE3, you should have a look in
thier docs[2] for actual syntax.

HTH

	Stephan



[1] http://www.postgresql.org/docs/current/static/sql-createindex.html
[2] http://www.sqlite.org/lang_createindex.html
-- 
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office      -     Mengendamm 16d      -     D-30177 Hannover
Internet: www.gdf-hannover.de      -      Email: holl at gdf-hannover.de
Phone : ++49-(0)511.39088507       -        Fax: ++49-(0)511.39088508