Hello,

I have a large table (~700 million rows, ~150 columns).  Initially after import, the database is very fast on primary key lookups, however after a few thousand creates/updates/deletes on the database, "sorted" (as reported by sys.storage), flips from true to false.  This results in major performance degradation.

What are the conditions under which a database can lose it's sorted-ness on the primary key column?  

eg:

sql>select schema, table, column, sorted from sys.storage where schema = 'test1' and table = 'cmdb' and column = 'pk_id';
+---------+-------+--------+--------+
| schema  | table | column | sorted |
+=========+=======+========+========+
| test1   | cmdb  | pk_id  | false  |
+---------+-------+--------+--------+

Thanks,
-Jeremy Norris