[MonetDB-users] CREATE INDEX syntax?

Hi Sjored -

I have a lot of questions, so I thought I start a few threads if that is all right.

What is the CREATE INDEX syntax? According to the manual it is

CREATE [UNIQUE] INDEX <index_name> ON <table_name> ( <column_name>, ...) ;

But whey I use this syntax, I get strange errors:

sql>CREATE INDEX "_tidx_usernames_2a" ON "Performance"."usernames" ("username"); !CREATE INDEX: no such table 'usernames' sql>select count(*) from "Performance"."usernames"; +--------+ | count_ | +========+ | 5 | +--------+ sql>

________________________________________________________ Richard Wesley Senior Software Developer Tableau Software Visit: http://www.trytableau.com/now.html