unique index access question

[skalyanaraman]

Hi,
I have created an unique index on the DOCID column in a table, where DOCID column is varchar(50) and unique alphanumeric.

lets say the unique index name is idxrdocid.

then, if I do
"set indexaccess=1;select DOCID from idxrdocid"

AM I GUARANTEED TO GET THE DOCID'S IN THE ASC SORTED ORDER, EVEN IF I DONT DO AN ORDER BY?
MY TESTING INDICATES THAT.

THANKS!!

[John]

If you select directly from the index you will get the records back in the indexed order, so in this case yes, they will be in ascending order.