I am a beginner in DB2.I created a table and also a unique index for the table.But after inserting data into the table,the contents are not in sorted order(according to the index).
create unique index ai_index on xxxxx(jnt_id asc)
where jnt_id is column in table of type char(4)
What might be the possible reason for the data not to be in sorted order??Is there any other method to sort the available data??