how to re-index (number) sorted sqlite table

how to re-index (number) sorted sqlite table

References

Reference NO 1

http://stackoverflow.com/questions/13644577/how-to-re-index-number-sorted-sqlite-table

Reference NO 2

http://www.sqlite.org/fts3.html

Reference NO 3

http://www.sqlite.org/lang_createindex.html

Reference NO 4

http://vufind.2307425.n4.nabble.com/Large-browse-indexes-SQLite-limits-td4654998.html

Reference NO 5

http://wiki.xbmc.org/index.php?title=XBMC_databases

Reference NO 6

http://osdir.com/ml/sqlite-users/2013-07/msg00476.html

Reference NO 7

http://forums.realsoftware.com/viewtopic.php?f=3&t=42516

Reference NO 8

http://search.cpan.org/perldoc?DBD::SQLite