Hi,
Can you show how to create an index for several columns ?
For example we got a table pcontrat and we wan't an unique index on 2 columns : cont_empl and cont_contrat. With Access it's OK, but we don't know how to do it with HXTT. We try :
CREATE INDEX IF NOT EXISTS PrimaryKey, PrimaryKey ON pcontrat (cont_empl UNIQUE PRIMARY KEY ASC, cont_contrat ASC)
But it creates two differents indexes ... How to create a composed index ?
Thank you.
|
For instance,
CREATE INDEX XlistJdbc_fid_felement ON test (id , date);
CREATE INDEX XlistJdbc_fid_felement ON test ((id , date) PRIMARY KEY) ;
CREATE INDEX XlistJdbc_fid_felement ON test (id+ date PRIMARY KEY) ;
|
Main
webmaster@hxtt.com