Index creation

[mohit_symb]

Hi,
I am creating two index in a single table but it is throwing error. How to create 2 index in one table using different columns??

[geraintjones]

Hi. Vectorwise tables can only have one index.

http://docs.actian.com/ingres-vector...sql-statements

[mohit_symb]

Hi,

thanx...Is there any workaround to do the same.

It created clustered index by deafault. How to create unique index??

[geraintjones]

You can't create a unique index. If you need to enforce uniqueness, use a constraint.