sql - Whats is efficient database design in sqlite when I only need to insert and retrieve smallest entry in an integer column? -

basically need min-heap functionality sqlite data storage.
lets need table 2 columns. 1st unique ids and
2nd integer value.
need the id smallest integer value.

any suggestions ??

you free on indexed columns

  create table table(      1 integer primary key,      2 integer   );   create index table_two on table(two);    insert ...    select min(two) table;