You must be the owner of a table or the DBA to create, alter, or synchronize a join index that includes that table. If you are not the DBA, you need to be the owner of the table and have RESOURCE authority in order to create a join index.
For details on inserting and deleting data, see Chapter 7, “Moving Data In and Out of Databases” For complete syntax of the CREATE TABLE, ALTER TABLE, LOAD TABLE, INSERT INTO, and SYNCHRONIZE commands, see the Sybase IQ Reference Manual. The sections that follow give details on other steps in creating a join index.
