[MonetDB-users] CREATE INDEX syntax?

13 Oct 2008

      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  ON   
( , ...) ;

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