Re: Correct use of an automatically created index on a primary key

> >CREATE TABLE user_file_read( oid AsnObjectId, userId integer, reader >VARCHAR(255), fileName VARCHAR(255), readStatus integer, PRIMARY KEY (oid) >) LOCK MODE ROW;> Better way is: CREATE TABLE user_file_read( oid AsnObjectId, userId integer, readerVARCHAR(255), fileName VARCHAR(255), readStatus integer ) LOCK MODE ROW; CREATE UNIQUE INDEX i_user_file_read1 on user_file_read(oid); ALTER TABLE user_file_read ADD CONSTRAINT PRIMARY KEY (oid) CONSTRAINT NAMEp_user_file_read1; > >SELECT {+INDEX(' 2828_63')} * FROM user_file_read_table order by oid UPDATE STATISTICS for your table and you don't need "optimizer directive".Now you can write: SELECT * FROM user_file_read_table order by oid nebojsa ------------------------------------ Remove spam block (DELETE_) to reply