Hello,
Does someone can tell me what's wrong with this code:

Alter TABLE Vendors
ADD INDEX vendeornameIDX if not EXISTS ON Vendors (Name) COMPRESS FULL

I am just trying to add an index into a existing table.

Thank you for your help

Marcel

Marcel,

Indexes are created with the CREATE INDEX statement, not ALTER TABLE.
In your case, it should be:

CREATE INDEX IF NOT EXISTS vendeornameIDX ON Vendors(Name) COMPRESS FULL

--
Fernando Dias
[Team Elevate]

Hello Fernando,
Thank you.
It works.

marcel