ordering for snapshot table