[MonetDB-users] CREATE INDEX syntax?
13 Oct
2008
13 Oct
'08
10:01 p.m.
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
5685
Age (days ago)
5685
Last active (days ago)
0 comments
1 participants
participants (1)
-
Richard Wesley