Dear All, Say I have 3 columns in one Table, with one INTEGER, two TEXT columns, If ROWID is manually inserted and made descending for 10000 records from 10000 to 1, (or even if random number for ROWID - both these cases), the memory occupied is more. Why is this so?
Is that indexing happens, If so, is entire table elements gets sorted? Thanks
